Update sets

[radhamanchi]

What is the first step in the process to import spreadsheet data into ServiceNow?

A. Select Import Set

B. Run Data Scrubber

C. Define Data Source

D. Create import Set

E. Set Coalesce

[Vishal Jaswal]

Hello @radhamanchi 

C. Define Data Source

Additonal Information:

1. Navigate to All > System Import Sets > Load Data module > Data Source

2. Select Create Table, enter the table name, select the source of the import (Data Source in this example) and choose the file(.xls).
Ensure that the first row in the Excel file matches the fields in your destination table for automatic mapping.

3. Click on “Create Transform Map.”

4. Provide a name and select the destination table (the table where you want to get this data to be added/uploaded).

5. Click on “Auto Map Matching Fields.” If required fields do not match, use “Mapping Assist” to manually map them.

6. Set “Coalesce” to “True” for at least one field in the related list. This field will act as the unique identifier.

7. Click “Transform” to complete the process.

Hope it helps!

[SakshamSahu]

Hi @radhamanchi 
The correct answer here should be: C. Define Data Source

Reason:The first step in importing spreadsheet data into ServiceNow is to define the data source. This tells ServiceNow where the data is coming from (e.g., an Excel file, CSV, XML, etc.).

If my Answer helps you, Please mark it as Helpful!

[Sandeep Rajput]

@radhamanchi The correct answer is 

C. Define Data Source

[Sandeep Rajput]

@radhamanchi Please mark the response an accepted solution if it addressed your question.