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,

[Diorella Angulo]

I did that. The system was asking me to create an index. I said OK, but not sure if that is fine.

This is the pop message I got when change the coalesce field to true for the field

After I did that, I tried to import the Excel and got the same issue. I have 5 records for the same and just one entry in the template. Any ideas? May be that is an issue in the Workflow? I can shared that if necessary.

[Ankur Bawiskar]

Hi,

Glad to know that my blog helped you.

Are you setting correct unique field as Coalesce=True

If match for coalesce field is found it would update; if not found then it would insert

Regards
Ankur

[Diorella Angulo]

Is this the field you are talking about. I had it deactivated.

[Ankur Bawiskar]

Hi,

share your field map and ensure you set 1 field as Coalesce=true

Regards
Ankur

[Diorella Angulo]

Ankur, 

I set up one field as coalesce to true but I'm still getting the issue. Do you think that this can be an issue in the Workflow? 

In the Workflow the script you shared for copying the date didn't work for me. I found that another person posted a different script and that worked.

Any suggestions?