Where is the Coalesce option on a Transform map?

Trish Mac · ‎05-01-2022

Hello,

I'm at a bit of a loss. There is supposed to be an option to choose if certain fields should be coalesced on a data import, however I don't see the option on the Transform Map or Mapping Assist forms. I want to coalesce on Category Description/Category and Sub Category Description / Subcategory. What am I missing please???

Thanks,

Trish

Kartik Sethi · ‎05-01-2022

Hi @Trish Mac

Once you are done with the Mapping Assist form, then go to the Related List of your Transform Map.

Under Related List Field Maps,

You can see the Column Coalesce (if it is already configured).
If you can't find the Coalesce field, then you can personalize the list and bring Coalesce field.

After Step1, you can add the desired Field Maps to Coalesce.

Please mark my answer as correct if this solves your issues!

If it helped you in any way then please mark helpful!

Thanks and regards,

Kartik

View solution in original post

Kartik Sethi · ‎05-11-2022

Hi @Trish Mac

Thank you so much for marking my answer as correct.

If you are coalescing 2 fields, they will be considered Composite Keys.

Please provide more details on the error that you recieved.

Thanks and regards,

Kartik