5 Replies Latest reply: Nov 3, 2015 6:28 AM by balraj ahlawat RSS

    hey i am trying to run this simple join but cant proceed , need your help:

    jhonatan ben ami

      Inv_Sales_Temp:

      LOAD

      [IVCOST],

      [IV] AS INV_IV,

      IVDATE AS INV_IVDATE,

      [CURRENCY]  AS INV_CURRENCY,

      FROM [lib://clinton/InvoiceItems.qvd] (qvd);

       

       

       

      LEFT JOIN  (Inv_Sales_temp)

      LOAD

      CUST,

      CUSTNAME,

      COUNTRY,

      CURRENCY

      FROM [lib://clinton/customers.qvd](qvd);

       

       

      LEFT Join (Inv_Sales_temp)

      LOAD

      CUST,

      COST

      FROM [lib://clinton/Trans.qvd]

      (qvd);