In Transform Map, Field map, how to make that if the source is empty, it does not replace the target field that does have data?

[Mauricio Guzman]

How can I do that in the transform map, if the source has the field empty, when updating the target that if it has data, it will not delete it?

[ersureshbe]

You should remove direct field mapping instead you can use transform script.

If(!source.u_variablename.nil())

{

target.variablename= source.u_variablename

}

[Allen Andreas · Accepted solution]

Hi, 

I believe if the source field is empty, it won't overwrite what is there for the target field.

On the transform map, you'll see this field: 

Only if that box is checked I believe the fields will be overwritten.

Please mark reply as Helpful/Correct, if applicable. Thanks!