Sales:
LOAD
//DOCNO,
TRXH_LOC_CODE,
"City Centre",
Channel,
// UPPER(LOCN) as Store,
DIVISION,
Division,
DIVISION & ' - ' & Division as DivisionName,
Division_Group,
// CATEGORY ,
CATEGORY AS group_code,
Group,
SUPP_CODE,
Supplier,
// SUPP_CODE&' - '& SUP_NAME as SupplierName,
PRODUCT,
// DESCRIPTION as Product,
// PRODUCT &' - '& DESCRIPTION as Product,
BRAND,
Brand,
WAC,
RSP,
LCPRICE,
// SOLDQTY,
// SALE,
Return_flag,
Date,
Year,
Month,
Day,
DateNum,
// TIME(Timestamp#(TIME,'hh:mm:ss TT')) as TIME,
// NAT_CODE,
// IF(NATIONALITY='unknmown','unknown', NATIONALITY) as NATIONALITY,
// if(NATIONALITY='Kuwaiti','Kuwaiti','Non-Kuwaiti') as NATIONALITY_Group,
// CASHIER,
// COUNTER,
LEVEL0,
LEVEL1 AS cat,
NegMflag,
// FRN_FLAG,
WAC1,
SUM(SOLDQTY) AS Sold_qty,
SUM(SALE) AS Sale,
SUM(WAC*SOLDQTY) AS COS
FROM [lib://QVDs (r)/Sales.qvd]
(qvd) ;
this error keeps coming out for me, can someone help me ?