Steps: Configure Staging Tables and Columns for Spreadsheet Data Sources

Import your spreadsheet data source.

Security:

Integration Operator
permission.

Data Designer
permission.

Go to

Integration

Design Integrations

From the

Data Sources

section, select the spreadsheet data source.

(Optional) From the

Source

prompt, toggle between the 2 options to compare the source with staging table:

Option	Description
Staging	View the data in the staging tables.
Spreadsheet	View the data in the spreadsheet source.

(Optional) From the

Data Components

section, drag and drop components into the staging table:

Join tables and union tables when you expand

Custom Table

SQL columns and subquery columns when you expand

Custom Column

(Optional) Click the prompt on a tab of a staging table.

As you complete the task, consider:

Option	Description
Manage Columns	Add and remove columns from the import.
Table Settings	Import Data Mode : All records replaced each time a data import is run : Default. Spreadsheet replaces the previous version in the staging area. Merge (add, update) received rows using the key columns : Spreadsheet merges with existing data by matching key columns. After selecting this option, you can set the Key Columns area. All received rows are new and so should be added : Spreadsheet adds to the table, leaving all existing data as-is. Sheet Has Header Row : Select to indicate rows that are headers instead of data. First Header/Data Row : Enter the row number of the first header row (if there’s a header row) or the first data row. Ignore Parsing Errors : Select when you want to ignore cells with errors, such as text appearing in a date column. Cells with errors import as empty. When you don't ignore parsing errors, the import fails if there are errors. You can use the error log to help identify parsing problems.
Key Columns	Select the key columns to match for merging spreadsheet data.
Exclude table from import	Remove the worksheet from the import.
Delete Table	Remove the entire table.
Download Data	Download the data according to the structure in the staging tables.

(Optional) Click the prompt on each column.

As you complete the task for Column Settings
, consider:

Option	Description
Column Type	Select the type of data used in the column.
Convert Column Type	Convert the data type of the column.

Advanced filters enable you to review a subset of your structure as you refine the staging tables.

Create or use a loader.