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