ServiceNow Application Development

Import set table

As a first step, we will create an import set table using the Load Data module. Open the System Import Sets | Load Data module, as shown in the following screenshot, and fill in the form using the following values:

• Import set table: Select Create table
• Label: Booking Req Import
• Name: (This field will be automatically populated)
• Source of import: Select File
• File: (Choose the file we exported earlier in the chapter)
• Sheet number: 1
• Header row: 1

The Label and Name fields tell us the label and name of the new table that will become our import set staging table. The source of the input that we are selecting here is a file, as we will upload a CSV file that contains rows that will be inserted into the new staging table being ...