Mapping tables serve as a dictionary between source value (Match, left column) and target value (Value, right column).
They work similarly to a V-Lookup: if a value matches the left column the corresponding value of the right column is inserted into the field. You can also include Regular Expressions in the match column, as described below.
EXAMPLE 1 - Manual Mapping
a. Go to Transformations --> Mapping Tables.
b. Click "+Add".
Click "+Add another entry" and begin manually populating the mapping table, where "Match" equals the value to search for in the source data, and "Value" equals the new value that will replace it.
Example Input 1
dim_A metric_1 UK 111 DE 222 US 333Example Output 1 dim_A New_Column metric_1 UK United Kingdom 111 DE Germany 222 US United States 333
EXAMPLE 2 - Using Regex Expressions
- Put '/' at the start and end of the entry to convert it into a regular expression. In the table below anything starting with 'DE_' would be translated to 'Germany'.
Example Input 2
dim_A metric_1 DE_Munich 111 DE_Berlin 222 DE_Frankfurt 333Example Output 2 dim_A New_Column metric_1 DE_Munich Germany 111 DE_Berlin Germany 222 DE_Frankfurt Germany 333