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:

Multi Account Column text file

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: