How to clear out the field on target table via Transform Map

[Manoj Narahari1]

I am having similar problem but via excel upload.  How to clear out the field on target table via Web Service + Transform Map

There are different asset managers and they want to upload their own different set of asset field to be updated. But the problem is either it ignores all the field values or copy. I would like to ignore field if there no column in the excel sheet and copy if there is column and value is empty.

Any help?

[Sharon14]

Before running the transform map, you may want to perform Mapping, you can leave the field un-mapped or you find transform scripts there.