he MAPPING statement provides an alternative to the JOIN statement in a very specific scenario: when you want to replace a single key value with a value from a lookup (mapping) table.
We prefix ' Mapping' to the load statement to tell Qlikview that a table is a mapping table.
• It can only have two columns, the first being the lookup value and the second being the mapping value to return.
• It is a temporary table. At the end of the script, QlikView automatically removes the table from the data model.
The mapping table is called with the 'Applymap()' function
Sample Code:
#####################################
Map_Price: //Mapping Table
Mapping LOAD * INLINE [
Category, Price
Adult, 10
Child, 5
Student, 6
Senior, 6
LoyalMember, 5
];
Tickets:
LOAD * INLINE [
Name, Class
Ann, Student
David, Adult
Sara, Senior
Keith, Child
Tom, Adult
Dave, Student
Sam, Adult
Monica, LoyalMember
Ethan, Student
Rose, Child
];
Price:
Load
Name,
Class,
ApplyMap('Map_Price',Class) as TicketPrice //Here we use applymap to look up for the ticket prices
