Records should not get insert, it should get update only if the Coalesce

[Community Alums]

Hi Experts!

I have a requirement, there is a string field on the target table called "PO number"  , I have made that field as Coalesce, while doing the bulk upload if the record found it is updating that record, if record not found it is creating a new record with blank detail, we don't want to create or insert a new record, we just want to update the records.

I have tried with below script in on before script it is not working it is still allowing to insert new record.
if(action =="insert")
ignore =true;

and I have tried with other script as well where I'm querying the target table and searching for the  record if not found then ignoring the insertion, that is also not working, kindly suggest me a solution for this.

Thanks in advance,
Chaithanya

[Ankur Bawiskar]

@Community Alums 

did you check what value the action variable holds?

[Community Alums]

Hi @Ankur Bawiskar 
Yes, I have checked the type of action holds "insert" only

Thanks,
Chaithanya

[Ankur Bawiskar]

@Community Alums 

then it should work fine

share onBefore transform script screenshot

[Community Alums]

Hi @Ankur Bawiskar 
There was one more onafter transform script, that was conflicting with Onbefore script, replaced onafter transform script with Business rule, now onbefore transform script is working fine to ignore the insert action.

Thanks,
Chaithanya

[Ankur Bawiskar]

@Community Alums 

Glad to know.

Please close the thread by marking appropriate response as correct.