how to use mapping load in qv?

Anonymous — Fri, 02 Apr 2021 07:37:16 GMT

explain me with example

Re: how to use mapping load in qv?

arvind1494 — Mon, 29 Jan 2018 12:11:06 GMT

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;