I want to update bulk record via import set and skip creating new record.

[gaurav72]

I have created an import set and transform map to update bulk records on the table.

I have set an unique column as Coalesce but I want to skip creating new record if record is not found.

When it find the record it updates it but created new record when unable to find it that I want to skip.

[tslogue]

I would try what Johns MP recommended but also there is a "Create New Record on empty Coalesce fields" field on the transform map that may need to be set to false as well 

[gaurav72]

Tried Johns Mp suggestion it worked for me, thank you !

[Johns_MP · Accepted solution]

Hi @gaurav72 ,

I think you can on the Transform Map Click On "Run Script" and use below code.

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

This code can also be written on the onBefore transform script as well.

This will ignore creating a new record in the transform table.

Let know if this solves your issues.

Mark helpful if it helps in solving the issues

[gaurav72]

Tried it in onBefore Script and it worked. - Thank you !!