This deprecated node denormalizes a field containing a list of values, outputting a record for each value in the list in a new field, effectively providing the inverse of the Reduce To List functionality.
The ListExpr property should be enclosed in single-quotes if it is a field name. The Delimiter property should be enclosed in double-quotes if it is a constant string literal ("," ":" ";" " " etc.) The ItemField property should not be enclosed in quotes.
Example:
ListExpr - 'statelist'
Delimiter - ","
ItemField - state
TrimItem - true
Input:
account:int statelist:string
11111111 FL, MA, NE
22222222 CA, AZ, NV, NM
Output:
account:int statelist:string state:string
11111111 FL, MA, NE FL
11111111 FL, MA, NE MA
11111111 FL, MA, NE NE
22222222 CA, AZ, NV, NM CA
22222222 CA, AZ, NV, NM AZ
22222222 CA, AZ, NV, NM NV
22222222 CA, AZ, NV, NM NM
If the input list field is empty, a single record will be output with an empty item field. Extra delimiters will cause records to be output with an empty item field.
Properties
ListExpr
Enter the delimited list of items.
A value is required for this property.
Delimiter
Optionally specify the delimiter character which separates items in the list.
The default value is "*".
ItemField
Specify the name of the new field to contain each list item.
A value is required for this property.
TrimItem
Optionally specify whether to trim the item values.
The default value is True.
Inputs and outputs
Inputs: in1.
Outputs: out1, multiple optional.