Driver

For file-based source only integrations when the Type is selected as "Multi-Column - All Data Type " in Map Dimensions, use the Driver source expression to load all data types for multiple dimension members of a selected dimension in a single row of data. The definition of the members to load can be included in a header record in the load file, or in the import format definition. Supported data types are: Numeric, Text, Smartlist, a Date. A driver dimension member can be assigned in the integration (as well as the header record or import format (member expression)). This source expression is only displayed in the integration when the members are not specified in the import format, or if the header row is not specified in the import format.

The parameter is null,"", "","". For example, specify: Driver=Account;HeaderRow=2;Column=3|5,8; to define the column dimension as "Account"; import columns 3 and 5 through 8; and use header row 2 to determine values for Account.

In another example, you could specify Driver=Account;Member="OWP_Employee Type","OWP_FTE","OWP_Applicable Union Code", "OWP_Merit Month";Column=3|4|7|5;. In this case, the column dimension is "Account" and import columns are 3,4,5,7. Target values for Account are listed after the member.

To specify a range of columns, use a , (Comma). For example 3,8 is column 3 through 8. Use | (pipe) to specify distinct columns 3|6|8 is columns 3,6,8.