Import set duplicate data

[srivatsa]

Hi,

I have an import set which is getting data from an XML to update data of records.

The XML will contain duplicate records sometimes, if there are 2 instances of a record, I want the second one to be accepted and the first one to be rejected.

Explanation: I have a table with 2 fields apm number and apm level field for which I am importing data from an XML source.

If you have two records in the import with same APM number, 

second one will have to override the first record value.

Please suggest what could be done, thanks!

[Dhananjay Pawar · Accepted solution]

Hi,

Can you set coalesce to true for APM field, Then it will update the data with second record.

Thanks,

Dhananjay.

[Dhananjay Pawar]

Hi srivatsa,

Did you tried my suggested option?

Thanks.

[srivatsa]

Works! hence marked answer as correct.

[Dhananjay Pawar]

Hi,

Glad it helped you.

Have a great day.

Thanks,

Dhananjay.