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.
Got feedback or spotted something we can improve?
We'd love to hear from you. Join the conversation in the Documentation forum!