10 Replies Latest reply: Feb 8, 2014 11:57 AM by Manish Kachhia RSS

    i want map product id but it is there in 2 tables how to map ? whether its possible or not?

    manoj kumar

      map1:

      mapping LOAD productid,

           description

      FROM

      M:\ONLYQLIKVIEW\DOCUMENTS\MAPPING\map.xlsx

      (ooxml, embedded labels, table is product);

       

       

       

       

      map2:

      Mapping

      LOAD productid,

           discount

          // promoDiscount

      FROM

      M:\ONLYQLIKVIEW\DOCUMENTS\MAPPING\map.xlsx

      (ooxml, embedded labels, table is discount);

       

       

      map3:

      Mapping

      LOAD customerid,

           [customer name]

      FROM

      M:\ONLYQLIKVIEW\DOCUMENTS\MAPPING\map.xlsx

      (ooxml, embedded labels, table is customer);

       

       

       

       

      tomap:

      LOAD orderid,

      ApplyMap ('map1','map2',productid) as pid,

       

       

      ApplyMap ('map3',customerid) as cid,

           productid,

           customerid,

           gross_amount,

           orderDate

      FROM

      [M:\ONLYQLIKVIEW\DOCUMENTS\MAPPING\map.xlsx]

      (ooxml, embedded labels, table is sales);