Transform map query

[lmadhurima]

I have a requirement to insert a new job record when he is a rehire instead of updating the existing job record due to coalesce

1.If a user ID is present in job record table and primary =false ,I have to insert a new job record instead of updating the existing record.

Can someone guide me please?

[Harsh_Deep]

Hello @lmadhurima 

Then uncheck your coalesce checkbox and check the condition in the run script.

if(source.field_name==false)
{then ok}
else{
ignore = true;}

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.