Expand From List - Data360_Analyze - 3 - 3.12

Data360 Analyze Server Help

Product type
Software
Portfolio
Verify
Product family
Data360
Product
Data360 Analyze
Version
3.12
Language
English
Product name
Data360 Analyze
Title
Data360 Analyze Server Help
Copyright
2023
First publish date
2016

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.

CAUTION:
This node has been deprecated and will not be supported in a future release. As an alternative, the Do While Conditional and Transform nodes can be used to provide similar 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.