While transforming empty records are getting created

[Mounika M]

Hi All,

We have schedules, in that schedules we are executing transform map, when we click on execute the transform map is also running and it is having script at run script part on import set table we are duplicate records and we are using coalesce but the empty records are getting created, could anyone please help on this.

Thanks in Advance!

[Weird]

Normally when using coalesce you wouldn't generate empty records, but there's an option "Create new record on empty coalesce fields" that you might have set to true.