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