Update sets

radhamanchi
Tera Contributor

Which of the following steps can be used to import new data into ServiceNow from a spreadsheet?

A. Select Data Source, Schedule Transform

B. Load Data, Create Transform Map, Run Transform

C. Define Data Source, Select Transform Map, Run Transform

D. Select Import Set, Select Transform Map, Run Transform

5 REPLIES 5

Rohit  Singh
Mega Sage

B. Load Data, Create Transform Map, Run Transform

 

If my response helped, please hit the Thumb Icon and accept the solution so that it benefits future readers.

 

Regards,
Rohit

Hi @radhamanchi ,

 

Please accept my solution as well, so that it will be helpful to other readers as well.

 

Regards,

Rohit

Shivalika
Mega Sage

Hello @radhamanchi 

 

Here, all seem to be correct or even partially correct. 

 

Option A) Select Data Source and Schedule Transform. 

---- Here we first need to create a Data source, then we need to created Scheduled Data Imports, where we select the data source. Then we need to create Transform maps and add them to data source. We can add multiple transform maps to data source and they will run as per the order you have specified. 

 

Option B)Load data, Create Transform map and Run Transform -

this is the basic process that is followed for test runs without any automation. 

 

C)This I already described rhe flow they follow for data source transformations. 

 

D)For import sets, we can import any file and then select the import set table and select the transform.map and run. We can also reprocess rhe existing completely processed import sets. 

 

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket. 

 

Regards,

Shivalika 

 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

 

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY

Shivalika
Mega Sage

Hello @radhamanchi 

 

Please confirm if you checked my answer. Kindly mark my answer as helpful and accept solution if it helped you in anyway, so that it can move from unsolved bucket to solved bucket. 

 

Regards, 

Shivalika 

 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

 

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeE