Map Values
The Map Values transformation component lets you map a value in an existing column to a different value in a new column, based on a specified condition.
Like the Fixed Flow transformation component, Map Values can be used to introduce mappings into your data—for example, mapping a non-descriptive code to a more human-readable name.
Use case
This component helps you to clean and standardize your data. For example, you can use it to:
- Map ICD diagnosis codes in healthcare data to the name of the condition to make your data easier to understand.
- Flag unusual transaction amounts in banking data—for example, by mapping transaction values less than $0 to "Refund".
Properties
Name = string
A human-readable name for the component.
Value Map = column editor
- Input Column: The name of the column output from the previous component used for comparison.
- Qualifier: Can be either Is or Not. Used to invert the filter if required.
- Comparator: Select the comparison operator.
- Less than: The value in the Input Column must be less than the value specified in the Comparison Value Column.
- Less than or equal to: The value in the Input Column must be less than or equal to the value specified in the Comparison Value Column.
- Equal to: The value in the Input Column must be equal to the value specified in the Comparison Value Column.
- Greater than: The value in the Input Column must be greater than the value specified in the Comparison Value Column.
- Greater than or equal to: The value in the Input Column must be greater than or equal to the value specified in the Comparison Value Column.
- Like: Sets a case-sensitive match of the value in the Input Column and the pattern in the Comparison Value Column.
- ILike: Sets a case-insensitive match of the value in the Input Column and the pattern in the Comparison Value Column.
- Similar to: Matches the value in the Input Column with an SQL standard regular expression pattern in the Comparison Value column.
- Null: Checks whether the value of the Input Column is the SQL null value.
- Blank: Checks whether the value of the Input Column is an empty string.
- Null or blank: Checks whether the value of the Input Column is either the SQL null value or an empty string.
- Value: A value entered by the user for comparison.
- Then Value: A value entered by the user that will be added to the data when the comparison is matched.
Column Name = string
The name of the output field that is passed to subsequent components.
Other = string
A value entered by the user when none of the conditions are matched.