Load Data: Documentation on how to load data from an excel file

BK14
Mega Guru

‎09-11-2023 09:28 AM

Hello all,

 

Does anyone have a documentation on how to load data from spreadsheet?

I have done that before but I am getting duplicated data and I have to delete thousands of records and start over and still getting duplicated data 5 times. My data is IP Ranges that are type IP Network. I get 3 IP Network, one IP Address Range and one u_discovery_range_item_import type. Not sure where I make mistake or the application has issue.

 

Please let me know if there is any documentation you can share. 

 

Thank you

bk

0 Helpfuls
  • 307 Views
2 REPLIES 2

subin ps1
Tera Contributor

‎09-11-2023 10:10 AM

Hi BK ,

 

You can go into the transform map and make the coelase field as active. refer the doc 

 

https://developer.servicenow.com/dev.do#!/learn/courses/tokyo/app_store_learnv2_importingdata_tokyo_...

 

Best Regards,

Subin

0 Helpfuls

sushma9
Tera Contributor

‎09-11-2023 10:14 AM

Hi @BK14 

Please make  coelase   Option  as true for the fields which is required in the Transform maps .

 

Please mark my answer if it helps you !!!

thanks ,

Sushsma

0 Helpfuls