6 Perform a Load that Includes Multiple Accounts in Columns with Numeric Data

In this example, the source data includes multiple values in a single row, instead of a single value on each row.

The source file for this example is named Multi-Account-Column.txt and includes the following data:

In this example, we will use the driver feature for the Amount dimension to specify the columns in the file that represent the accounts.

To create the integration to perform a load that includes multiple accounts in columns with numeric data, you will:

• Add a Name and Description

• Add the Source File

• Add the Target

• Map the Dimensions in the Source to the Dimensions in the Target

• Enter Mapping Rules

• Define Additional Options

• Run the Integration