Switch case
This processor applies rules to compute a new column based on the input column values.
Rules
Rules are defined as a list of key-value pairs. When a key is found in the input column, the corresponding value is set in the output column.
If a column row matches no key, the value for unmatched row is empty by default.
You can set a default value in the
Value
for
unmatched
rows
field.
In order to add as many matching conditions as necessary, click on the
ADD
RULE
plus icon.
Note
The matching between column values and key values is based on a strict equality comparison.
Normalization modes
By setting the normalization mode, you can specify whether you want the processor to perform:
-
Case-sensitive matches (‘Exact’ mode)
-
Case-insensitive matches (‘Lowercase’ mode)
-
Accents-insensitive matches (‘Normalize’ mode)
