If i select coalesce is true for two fields in transform map what will happen?

hema sundar · ‎04-21-2023

Anil Lande · ‎04-21-2023

An example would be:

If you set Email and Mobile no as coalesce true then if your imported data matches with Mobile and email field data of existing record then it will update that record.

If Mobile matches but email is not matching then it will create new record or vise versa.

Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.
Thanks
Anil Lande

View solution in original post

Anil Lande · ‎04-21-2023

It will consider and operation for both mappings.

If column1 matches and column2 also matches with existing record then it will update records.

otherwise it will create new record.

Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.
Thanks
Anil Lande

Anil Lande · ‎04-21-2023

An example would be:

If you set Email and Mobile no as coalesce true then if your imported data matches with Mobile and email field data of existing record then it will update that record.

If Mobile matches but email is not matching then it will create new record or vise versa.

Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.
Thanks
Anil Lande