Coalesce multiple fields in transform map to make updates in the target table through import sets

[Sumanth5]

Hello All,

 I have a transform map where I need to coalesce two unique fields to check the fields and update the existing records in the target table through the import sets. We are importing data through the import sets and transforming the data through the transform map. We'll be updating our existing records and at the same time creating the new records through the import sets. For the update scenario I have coalesced two fields say A, B and the rest of the fields are C,D.After setting the two fields A,B to coalesce true in the field map, I tried to update the records(updating Field C) in the target table through the import set, but it is creating a record instead of updating the existing record(for field C). Please advise me on this, thanks!

[sethivarun]

before importing do make sure that you indexes created on the columns you are using to coalesce. 

which type of fields are you using to coalesce? reference, text , choice .. what?

also, do have a look if you have case sensitive checked or unchecked base don your needs

[Sumanth5]

Hello Sethivarun,

Thanks for replying.I'm coalescing on the referee fields and my target fields are set to reference and import set fields to string and I'm indexing upon coalesce in the transform map. But it's creating a record instead of updating. We're sending Id's and our transform checking the related tables to populate the names of those Id's in the target table. Do you sense anything wrong in my approach? and do you want me to try something else like source mapping on the fields itself?

[Cory CJ Wesley]

Also ensure that you don't have a whitespace issue if you're matching strings.  Ensure that if you're coalescing on a reference field and supplying the display value rather than the sys_id that you select the appropriate target field in the source mapping like below.

[Sumanth5]

Hi Wesley,

Thanks for the reply. Yes, I'm matching it to the reference in target field and it's a string field in the import set. But I'm little confused about understanding the explanation. Could you please elaborate me the scenario and FYI I'm coalescing two fields.