Processing multi-value data

You can load multi-value data into a data domain by specifying the delimiter used to separate multiple values. But if you want to process multi-value data before loading it, convert it to a list data type

Two options are available for loading multi-value attributes:

If the multi-value field is string data, you can specify the delimiter character used to separate the values. This option is the recommended approach, especially when loading multi-value data from flat files (such as .csv files) or from database input.
Multi-value data can be converted to a list container. This option is recommended when loading multi-value data from complex input (such as JSON or XML) or if you need to process the individual values in the multi-value

To convert the input data to a list data type, use a Transform component. Within the Transform component, use the split() CTL function to convert the input of a multi-value field into a list data type. This function takes two parameters: the input string to be converted to a list, and a regular expression. The input is split whenever a match is found.

For example, suppose the value of the DimEmployee_DepartmentName field is multi-value, and uses dashes as the value separator. To generate a list data type for this input, you might use the following CTL expression: split($in.0.DimEmployee_DepartmentName, "-").

The configuration of new attributes defaults to single-assign. You should configure attributes to support multi-assign prior to loading data.