Array splitting is what you do if you have a list of values in a single cell delimited by a character (a comma, semi-colon, etc.), and want each of those delimited values in a separate row.
The following example will take a table like
and produce a table like
Use the sample table shown above and import it into your Storage. Then set the input and output mapping for your transformation.
The following script will take each row of the source table, and split the column whose name is specified in the
splitCol variable by the character specified in the
splitChar variable. The resulting values will be put
together with their ID specified in the
idCol variable, and they will also be assigned a new sequential ID
When you run the transformation, you will obtain a table with three columns:
globalId– ID of each row in the original table (the name of the id column is in the
globalPos– sequential ID of each value within the original row, and
globalVal– each value that has been split out of the original array column (the name of that column is specified in the