Split invalid cells into another column
This processor takes all values of a column that are invalid for a specific meaning and moves them to another column.
Example
With the following data:
icol |
42 |
Baad |
With parameters:
-
Column: icol
-
Column for invalid data: bad_icol
-
Meaning to check: Number The result will be:
icol |
bad_icol |
42 |
|
Baad |