Transform Map coalesce field

[SohamJ]

In a transform map for user table, there are 2 coalesce fields with an OR condition. If the source user_id is found in the user table, then update the record. If source user_id is not found, then check for source email. If source email is found in the user table, then update the record. If neither source user_id is found, nor source email is found in the user table, then create a new record.

[Dr Atul G- LNG]

Hi @SohamJ 

here is working:

When coalescing on multiple fields, all coalesce fields must be a match for there to be a collision. Matching some coalesce fields but not all does not produce a match.

• If a match is found using the coalesce fields, the target record is updated with the information imported from the staging table.
• If no match is found, a new record is inserted in the database.
• If no fields are coalesce fields, records are always inserted on import.

[J Siva]

HI @SohamJ 
Coalesce field doen't works like this.
Please chcek the reposne from @Dr Atul G- LNG .
You should plan accodingly.
Regards,
Siva

[SD_Chandan]

Hi @SohamJ ,

For more info & detail understanding you can refer the solution of this Thread 
https://www.servicenow.com/community/itsm-forum/what-is-coalesce-explain-with-example/td-p/2341075

Mark it helpful if this helps you to understand. Accept solution if this give you the answer

[Ankur Bawiskar]

@SohamJ 

You cannot handle it via Coalesce field.

Don't have field map for this.

Handle this using onBefore transform script.

If my response helped please mark it correct and close the thread so that it benefits future readers.