Transform map

[ma kaiyue]

I set two fields in the transform map with coalesce=true: Asset tag and serial nubmer.
But when I imported the data to update it, the following happened:
1. When the asset tag is different and the serial number is the same, it is not updated
2. When the asset tag is the same but the serial number is different, insert a new record
Why is that?

Thanks in advance！

[Dhananjay Pawar]

Hi,

If you have set 2 fields as coalesce then it will check for two fields in target table and if it finds, then it will update the target table record otherwise it will create the new record in target table.

Thanks,

Dhananjay.