Qlik Community

Qlik Connectors Discussions

Discussion Board for collaboration regarding Qlik Connectors.

wolverine07
Not applicable

how to use mapping load in qv?

explain me with example

Tags (1)
1 Solution

Accepted Solutions
arvind1494
Not applicable

Re: how to use mapping load in qv?

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;

1 Reply
arvind1494
Not applicable

Re: how to use mapping load in qv?

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;