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!

[Pato_Herrera]

hello,

how to mark coalesce field??

[Bhagyashri Sort]

Hi,

 As dhananjay said, make that field coalesce. after mapping a fields in transform map, set coalesce value to true for particular field.

https://community.servicenow.com/community?id=community_question&sys_id=840d0769db9cdbc01dcaf3231f96...

Mark it correct and helpful.

Thanks

Bhagyashri Sorte.