Field Normalization Transform

image_pdfimage_print

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:

 

image_pdfimage_print