Map

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 QlikView. 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 * as field list indicates all fields. The wildcard characters * and ? are allowed in field names. Quoting of field names may be necessary when wildcards are used.
mapname The name of a mapping table previously read in a mapping load or mapping select statement.

Examples and results:

Example Result
Map Country Using Cmap; Enables mapping of the field Country using the map Cmap.
Map A, B, C Using X; Enables mapping of the fields A, B and C using the map X.
Map * Using GenMap; Enables mapping of all fields using GenMap.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?