Not able to update target record using import sets

[hari6275]

Hi,

For some operation i was working on the import sets and for some tables like problem and incident it is creating new records every time even though i set the coalesce filed for the number is true and choice action ignore ....for example if i have an incident number INC1234 and i want to update that record using import sets it is creating new record with same incident number   INC1234 any idea what will be the issue.

thanks in advance

[Shishir Srivast]

Please check this if it helps.

Export and import records as XML files to ensure the records have the same Sys ID

Import set table data is being duplicated when running 2 transforms

How collisions occur and how to avoid them

[sarfraz3]

Hi Srihari,

It seems that importing sometimes create minor troubles. I will advise you to create a new transform map once again and use it.

thanks

[Alikutty A]

Hi Srihari,

I would suggest you try this once and see if it works, I had once came across the same issue.

On your coalesce, set coalesce on empty field.

Please see my response on Not Able to 'post' (insert)incident using import set in rest API

Thank You

Please Hit Like, Helpful or Correct depending on the impact of response

[hari6275]

hi,

The issue is resolved i don't know how but it is working fine now thank you for your responses which are helpful.

thank you