This transform splits one row with n comma-separated values in one column into n rows, where each output row contains only one of the n comma-separated values in this column. Rows with only one value in the corresponding column remain unchanged. Separating values are not limited to commas; other separators can also be configured.
“Ignore Empty Values” option
If checked, then there are no rows generated for empty values in the column to split.
(Example: A,,B,,C : 3 output rows if checked, otherwise 5)
“Ignore Duplicate Values” option
If checked then there are no rows generated for duplicates in the column to split.
(Example: A,B,B,A,A : 2 output rows if checked, otherwise 5)
Example:
Input data:
Output data:
Updated April 8, 2025