coalesce on multiple fields in transform map

caffry · ‎12-05-2018

i need to have coalesce on two fields where one field is the number field and the other is name field.

it should check for both name and the number field then it should update the record, but for me even if the name field is not present the field gets updated..

Alikutty A · ‎12-05-2018

Thats correct, It would insert the record because now it checks the unique combination of name and number. It does not check just the name alone.

For eg you have an entry with Name as Don and number as 123 and a new entry is imported with name as Don and number as 124, the latter entry is new combination of name & number (Since both are added as the coalesce). So it would definitely insert which is working as expected. Again, If you need to update then you should be sending the same combination of Don and 123

View solution in original post

Alikutty A · ‎12-05-2018

unique combination is what it checks. This is how it works, it is concept of composite keys in SQL.

There is no unique combination for Don with 124, so it inserts. You need to evaluate your requirements and set coalesce as required.

caffry · ‎12-05-2018

so there is no possibility of using two fields as coalesce,without comparing the combinations.

Alikutty A · ‎12-05-2018

Right, thats the default behavior. I guess you just need to keep number alone as the coalesce and it should work.

Edgar10 · ‎11-09-2022

Hi Caffry ,

I think the correct answer to you question is the Choice action.

If you have multiple coalesce in a transform map expose the field Choice action and set the value to reject instead of create.

Regards,

Edgar