Transform map to avoid insert if record matches

[Swati k1]

Hi All,

during dataload , we want to ignore insert record if the same record already existing in table , which way can we ignore inserting record ?can we update reject in choice action or need to write transform script?

[Musab Rasheed]

You mean to say if record doesn't exist then create or else don't create/update right.? Try below code once keeping coalaece as true as well. Give a try.

if(action =="insert" || action == "update"){
    ignore = true;
}