Transform Map Choice Action reject is not working

[adi91221]

Hi Community

I Created a Transform Map and Mapped the field and for my unique field kept choice action as reject and coalesce as true   still it is inserting new records.

Thanks

Adi

[James Michaels1 · Accepted solution]

I'm not sure about the specific way you are doing it currently but we have in the past used an onBefore transform script with the below code. Hopefully this works for you.

if (action == 'insert') { 
   ignore = true;
}

[prineshkumar]

Hi,

While performing the choice action the field should be the reference type or choice type.

I believe your unique filed is not choice or reference.

-prinesh