"NL" into "Netherlands", or a status flag "1" into "active". The list is checked from top to bottom and the first match wins; a value that matches nothing is passed through unchanged.
Fields
Sample data
Input:
Map value using dictionary
Converts input from one value into another using a lookup dictionary. For example, the value “1” into “One”, “Yes” into “Si”, etc.
Converts input from one value into another using a lookup dictionary. You give it a set of “from” and “to” pairs, and when an incoming value matches one of the “from” entries it is replaced by the matching “to” entry. This is ideal for translating codes between systems, for example turning a country code
Output: