When importing data from a spreadsheet, which step defines where the incoming data columns will be written in the receiving table?
Correct Answer: A
When importing data from a spreadsheet into ServiceNow, the step that defines where incoming data columns will be written in the receiving table is Field Matching.
Steps in the Import Process:
Select Data Source - Choose the spreadsheet (CSV, Excel, etc.) that contains the data.
Load Data - Uploads the data into a temporary staging table.
Create Transform Map - Defines the mapping between the source data and the target table.
Field Matching ✅ - This step matches the columns from the source data to the fields in the receiving table.
Schedule Transform (if needed) - Optionally schedule automatic data transformation.
Why Are Other Options Incorrect?
B . Load Data ❌
This step only loads data into a temporary table and does not define field mapping.
C . Select Data Source ❌
This step is only about choosing the input file, not about mapping fields.
D . Schedule Transform ❌
Scheduling only determines when a transformation runs but does not define field mappings.
E . Create Transform Map ❌
While transform maps define relationships between source and target tables, Field Matching is the step that actually aligns specific fields.
Reference:
ServiceNow CSA Documentation - Data Import Process & Field Mapping
ServiceNow Product Documentation - Transform Maps & Field Matching (https://docs.servicenow.com)