Split Array

1.3.10.58 Split Array

The Split Array processor splits an input array attribute into a number of standard attributes such as Strings, Numbers, or Dates depending on the type of the array input. This can be used as a quicker way to extract array element values into separate attributes than using many instances of the Select Array Element processor.

The following table describes the configuration options:

Configuration	Description
Inputs	`Array to split`: The array to be split to extract elements.
Options	`Number of attributes`: The number of attributes to output. When the input array is too small the value set in “Default output" is used for missing values. If the input array has too many elements, these are trimmed. `Default output`: The value to use if the array does not contains sufficient data to fill all output attributes. If the value is blank then leave this option empty.
Outputs	Output is the data view that shows input arrays with corresponding output attributes in order of inputs. Its also shows the number of attributes along with the default options set.

Note:

If input array's elements are blank or null, they will be output as blank or null, not as the “Default Output".

Output Filters

None

Example

Input Value	Number of attributes	Default Output	Output
Input Value	Number of attributes	Default Output	1	2	3	4
(Apple) (Grape) (Jack) (Matt) (Ginger) (Carrot) (Tom)	3	<Not set>	Apple	Grape	Jack	N/A
(Apple) (Grape) (Jack) (Matt) (Ginger) (Carrot) (Tom)	4	<Not set>	Apple	Grape	Jack	Matt
(<Blank>) (Grape) (Jack) (Matt) (Ginger) (Carrot) (Tom)	4	<Not set>	<Blank>	Grape	Jack	Matt
(<Null>) (Grape) (Jack) (Matt) (Ginger) (Carrot) (Tom)	4	<Not set>	<Null>	Grape	Jack	Matt
(<Blank>) (Grape) (Jack) (Matt) (Ginger) (Carrot) (Tom)	4	<Not set>	<Blank>	Grape	Jack	Matt
(Apple) (Grape)	3	<Not set>	Apple	Grape	<Blank>	N/A
(Apple) (Grape)	3	Jack	Apple	Grape	Jack	N/A
()	3	<Not set>	<Blank>	<Blank>	<Blank>	N/A
()	3	Jack	Jack	Jack	Jack	N/A
<Null>	3	Jack	Jack	Jack	Jack	N/A
<Null>	3	<Not set>	<Blank>	<Blank>	<Blank>	N/A
(<Blank>) (<Blank>	4	Jack	<Blank>	<Blank>	Jack	Jack
(<Null>) (<Blank>)	4	Jack	<Null>	<Blank>	Jack	Jack