The map ... using statement is used for mapping a certain field value or expression to the values of a specific mapping table. The mapping table is created through the Mapping statement.
Syntax:
Map fieldlist Using mapname
The automatic mapping is done for fields loaded after the Map … Using statement until the end of the script or until an Unmap statement is encountered.
The mapping is done last in the chain of events leading up to the field being stored in the internal table in Qlik Sense. This means that mapping is not done every time a field name is encountered as part of an expression, but rather when the value is stored under the field name in the internal table. If mapping on the expression level is required, the Applymap() function has to be used instead.
Arguments:
| Argument | Description |
|---|---|
| fieldlist | A comma separated list of the fields that should be mapped from this point in the script. Using |
| mapname | The name of a mapping table previously read in a mapping load or mapping select statement. |
Examples and results:
| Example | Result |
|---|---|
|
|
Enables mapping of the field |
|
|
Enables mapping of the fields |
|
|
Enables mapping of all fields using |