Transform map updating record even if field map is empty?

[astanley]

I have a transform map with two field maps:

end_date

user_name

The transform map coalesces on the user_name field and updates the end_date field on the user table. I also have a before transform script for if the action is insert, then ignore. 

It looks like even if the end_date is empty from the source staging table, the user record is still updated. I only have two field maps so I'm unsure why it is updating if there is nothing to update? I have the check box for "Copy empty fields" unchecked/set to false.

How can I stop the transform map from updating the record if a username match is found, but the end date field is empty?

[Mohit_Gupta · Accepted solution]

Hi @astanley 

Please use below example

Use an OnBefore tranform script, 
if (source.end_date.nil()){
ignore = true;
}

I hope this helps 

Please mark my answer correct if this helps you 

Thanks

Mohit