The Zurich release has arrived! Interested in new features and functionalities? Click here for more

Hi Getting Error: Table contains duplicate column names

santoshbharat
Giga Contributor

Hi Guys,

I am stuck in a scenario where i supposed to add a field called "ivr_integration" to an import set table.I created the same field in sys_user_table (ivr_integration ).

Then i created the transform map with mapping assist and run the transform.

But when ever i am trying to import the data one new field ivr_integration is getting created in my import set & Getting an error "Table contains duplicate column names" in Transform map .

Please suggest me what needs to be done to fix this

Thanks,

Santosh

4 REPLIES 4

Pradeep Sharma
ServiceNow Employee
ServiceNow Employee

Hello Santosh,



Can you please review field maps under transformation map and ensure all column names are distinct?


Hi Pradeep,



I verified all the fields in the transform map are distinct.


Hi Santosh,



Can you check the import set table fields if you alrdy have the ivr_integration field and check the import sheet as well.



Thanks


Alikutty A
Tera Sage

Hi,



Can you please try deleting the field and then reloading the excel directly without creating a new field?




Thanks


PS: Hit like, Helpful or Correct depending on the impact of the response