Transform map： coalesce = true

[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 record, 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！

[Tai Vu]

Hi @ma kaiyue 

It's required to match both fields in your case (asset tag & serial number) to perform the update action.

Coalescing

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.

Cheers,

Tai Vu

[ma kaiyue]

Yes, but why is there no new insert when the asset tag matches but the serial number does not？

Thanks！

[Weird]

Do the import logs say anything about that?
Potentially you could have a BR which prevents insert if the serial number already exists.

[Tai Vu]

Hi @ma kaiyue 

The problem might be because of certain rules (if the Run business rule checkbox is enabled) or Transform Scripts that are preventing the data from being inserted completely.

Let's review the Transform History. You can find the error message associated with the root cause in the Import Set Row Errors related list.

Cheers,

Tai Vu