how to use mapping load in qv?

[Anonymous]

explain me with example

[arvind1494 · Accepted solution]

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

Resident

Tickets;