Transform Map Overwrite Issue: Non-Empty Target Fields Not Replaced by Empty Import Set Values

[颯史小]

Please help identify the cause of the following issue:

When importing data from an Import Set table to the target table, existing non-empty fields are expected to be overwritten with empty values, but they are not being overwritten.

The Copy empty fields option is set to true in the Transform Map definition, so empty values should overwrite existing data. I have also verified that the incoming import data is indeed empty.

What could be preventing the overwrite with empty values?

[Ankur Bawiskar]

@颯史小 

do you have field map for that target field in your transform map? then only it works

see if source value is actually empty and doesn't contain any space character etc

is the target field readonly?

any before insert/update BR blocking from making it empty?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏