Step 3: Specify Selectors

The next step is to specify which columns of your file you want to map to fields on entities.

If you’ve already uploaded a file and want to select the columns of your entire file, we recommend clicking + Add Default Selectors. This will add selectors for all columns of your uploaded file.

Note: If you upload a new file and want to regenerate Default Selectors, you can use the Combo Button to “Delete All Selectors” and then you will be able to re-add all “Default Selectors” which will be detected using the currently uploaded file.

To manually add a selector, click + Add Selector to get started.

Enter the Header, which is simply the display name of the Column Header in your data preview table.

Has Header Row (both CSV and Excel)

If your file contains a header row, you have two ways in which you can select columns.

• Header Value
  • Use the exact value of a cell in the first row of your data to extract data from a column
• Numeric Index
  • Use numeric indices, starting with an index of 0, to extract data from a column.

Note that whichever method you choose, the result is the same. In both cases, since you’ve specified that a header row is present, the first row of data will not be extracted. Additionally, you can choose to select some columns with Numeric Indices, and some with Header Values.

Once you’ve specified the Header and Path, click Save to add one selector, or Save & Add Another to add multiple.

Note that when using default selectors, the Header Value method is used.

Note

If your sheet contains more than one column with the same header value (e.g., two columns are called “Keywords”), you will receive an error that duplicate headers exist. In this case, you should Set Has Header to false and delete the first row (which was your header row) using the Filter Rows transform.

Does NOT Have Header Row

If your file does not have a header row, the steps will differ based on the file type. Proceed to the relevant section below.

Excel

If your file does not contain a header row, you have two ways in which you can select columns.

1. Numeric Index
   • Use numeric indices, starting with an index of 0, to extract data from a column.
2. Alphanumeric Index
   • Use alphanumeric indices (A, B, C, etc…) to extract data from a Column.

Note that whichever method you choose, the result is the same. In both cases, since you’ve specified that a header row is NOT present, the first row of data will be extracted. Additionally, you can choose to select some columns with Numeric Indices, and some with Alphanumeric Indices.

Once you’ve specified the Header and Path, click Save to add one selector, or Save & Add Another to add multiple.

Note that when using default selectors, the Alphanumeric method is used.

CSV

If your file does not contain a header row, you must select columns using a numeric index of the column. Your first column should be specified using an index of 0.

Once you’ve specified the Header and Path, click Save to add one selector, or Save & Add Another to add multiple.

Note that when using default selectors, the Alphanumeric method is used.

JSON Files

The next step is to specify which pieces of that JSON file you want to map to fields on entities.

Selectors are specified using the JMES Path for the specific element you want to extract from your JSON file response.

Click Save to add one selector, or Save & Add Another to add multiple.