Select the column containing the values you wish to map.
Define the ‘map-from’ value. Click in the source field and the popup
provides suggestions from the first 2000 distinct values in the column.
If desired, change the match type from ‘equals’ to ‘contains’
if you want a mapping to apply where any part of the source value matches the ‘map-from’ value specified.
Now enter the desired mapped value. Quantemplate provides
suggestions based on previous mappings.
To add another mapping, click on the blank entry below and repeat the
Finally configure the output settings. By default the mapped values will be written to the same column. To
write the values to a new column, enter the new column name. Select whether to leave unmatched values unchanged or change to a new value.
Working with blank values
Sometimes the source dataset contains blank values – entries where no value has been entered. These can be mapped to another value (e.g. ‘Unknown’) by selecting the item (Blank) from the list of map-from suggestions. Alternatively if you wish to map a known value to a blank, select (Blank) from the list of map-to suggestions.
Click the autofill button to automatically create new entries from the first 100 unique
values in the source column.
Mapping company name
Your data sources all use different names for the company
NEWCO. The Map Values operation changes these values to match the value in your data warehouse.
Values in source data
Mapping to risk codes in a new column
Source data contains column of Class of Business with three values:
Property, Engineering, Marine. Based on these values each row can be assigned a risk code in
a new column (GI Policy Ref) to enable the data to be processed in a Catastrophe Risk Model.