Load Data from Attachment (Catalog Item) to a Target Table

[Diorella Angulo]

Hi ServiceNow Community,

I'm looking for a solution to import data provided in a Excel file in a Catalog Item into a Target Table.  

I was following this article published by @Ankur Bawiskar by I'm getting duplicated values in the table, and I don't know how to resolve it.

Data load and transform via Catalog Item - Developer Community - Blog - ServiceNow Community

Do you know any other method to populate a table using a Excel provided in a Form?

I really appreciate any help.

Regards,

[Anil Lande]

Hi,

Have you used coalesce in your transform map which is used in this setup?

You need to find a unique key and apply a coalesce on that field or use multiple columns as coalesce=true.

Thanks,
Anil Lande

[Diorella Angulo]

Hi Anil, thanks for your reply.

Is this the field you are talking about? 

I checked that and I'm still getting duplicated values.

These are the values in the Excel file

and this is what I'm getting on the table.

I really appreciate any help on this.

Regards,

[Anil Lande]

in your transform map, at least one field should be coalesce=true.

Check field mappings on transform map.

Thanks,

Anil Lande

[Anil Lande]

Set one column mapping as true (eg. new finished good/part number). 

So when you upload data next time, the record mating this column value will be updated. If new part number id found then it will create new record.

Part number will be primary key for your transform map. 

Thanks,
Anil Lande