How do I map fields to each other?

To map a more specific set of fields (such as city names) to a more general set of fields (such as region names), use the case statement.

The following example uses the case function to map cities to regions: