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

gaurav72 · ‎01-04-2023

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.

Johns_MP · ‎01-05-2023

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

Regards,
Johns M P

View solution in original post

tslogue · ‎01-04-2023

Set the 'Choice Action' field on your field map records to 'Ignore' instead of 'Create'. It defaults to 'Create' unless you change it. I usually just do it from the list view when lookin at the field map related list on my transform map record.

gaurav72 · ‎01-04-2023

I have 2 fields in transform map one to compare the Coalesce field and other one to update the value. Do I need to set both to 'Ignore' ?

tslogue · ‎01-04-2023

I would set both of them to ignore

gaurav72 · ‎01-05-2023

Unfortunately it is not working, it is still created new records