1 Reply Latest reply: Jan 29, 2018 7:11 AM by arvind pednekar RSS

    how to use  mapping load in qv?

    ravi maurya

      explain me with example

        • Re: how to use  mapping load in qv?
          arvind pednekar

          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;