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

[Arav]

Hi,

Try setting the "Choice action" field on transform map entry to "reject" so the row gets skipped when no reference is found in the underlying table.

Thanks,

Arav

[Abdul Azeem1]

Hi Arav,

Thank you for prompt reply.

If I do as suggested then how the record will get inserted ?

[Arav]

Abdul,

The record gets skipped only if the reference field value is not found in the underlying table.

Thanks,

Arav

[Arav]

I suggested to use "reject" as you are using the reference field as coalesce. If your intention is to insert records even when there is no match in the underlying reference table, then use Choice action as "ignore".