Ignore row if Coalesce field is empty in source table

[Abdul Azeem1]

Hi Now Community,

I have a transform map where one field is marked as a Coalesce and Create new record on empty coalesce fields is unchecked still the records are getting inserted / updated.

Is there anything I'm missing here ?

TIA

[Ankur Bawiskar]

Hi,

If coalesce field is empty then that checkbox should work i.e keeping it unchecked

You can also use onBefore transform script

(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {

	// Add your code here
	if(source.u_field.nil())
		ignore = true;

})(source, map, log, target);

Regards
Ankur

[Abdul Azeem1]

In my case it is not working. I keep that unchecked. I will try the onBefore transform script if no option is working.

I have below configured at field map. Hope its correct.

[Mahendra RC]

Hello Abdul,

Can you please once set the Choice action as Reject and check if it is restricting the records from creating.

Thanks

[Abdul Azeem1]

Hi Mahendra,

No still inserting when set as Reject.

Thanks