0 Replies Latest reply: Nov 3, 2015 8:39 AM by jhonatan ben ami RSS

    Invalid Path

    jhonatan ben ami

      HEY I AM TRYING TO RUN THIS SCRIPT BUT I AM KEEP GETTING AN ERROR:

       

      Inv_Sales_Temp:

      LOAD

      IVCOST,

      IV,

      CURRENCY ,

      TOTPRICE AS IVA_TOTPRICE,

      BONUSFLAG AS IVA_BONUSFLAG

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

      WHERE IVCOST>=100000;

       

       

      LEFT JOIN (Inv_Sales_Temp)

      LOAD

      CUST,

      CUSTNAME,

      COUNTRY,

      CURRENCY

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

      WHERE COUNTRY ="ISRAEL"or "USA" ;

       

       

      LEFT Join (Inv_Sales_Temp)

      LOAD

      CUST,

      COST

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

      (qvd);