5 Replies Latest reply: Feb 8, 2014 12:55 AM by Sudeep Mahapatra RSS

    great confusion? i want map product id in 2 tables how to map?if i use join giving syntax error

    manoj kumar

      map1:

      Mapping

      LOAD productid,

           description

      FROM

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

      (ooxml, embedded labels, table is product);

       

       

      join

       

       

      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);