Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Sheet number in load data

sanju
Kilo Contributor

‎08-16-2018 02:26 AM

Hi all,

I have to know how to specify the sheets in the excel in load data, example i have two sheets which is sheet1 and sheet2 both the sheets contains data, even if i provide 1,2 in the sheet number field i can see only one record is been created in the import set and in that record i can find the fields of the sheet1 and sheet2 but the sheet2 values are not available. From here what i want is when the excel is been loaded, it should create two separate records in the import set for sheet1 and sheet2. Any help is really appreciated.

 

regards,

Sanju

0 Helpfuls
  • 1,664 Views
2 REPLIES 2

Anurag Tripathi
Mega Patron
Mega Patron

‎08-16-2018 02:34 AM

You have to specify one sheet at a time.

 

-Anurag

SaiRaviKiran Ak
Tera Guru

‎08-16-2018 10:40 PM

Hi,

 

To Solve your issue,You have to import your data twice.

When you are importing for the first time you can give sheet number as 1 and when you are importing second time give sheet number as 2.

Thanks,

Ravi