Can someone assist me?
why do I keep getting Invalid expressions?
Thank you
TempSalesNew:
LOAD
ItemID,
Date ("Date",'DD/MM/YYYY') as Date,
CampaignID,
DocumentNumber,
StoreHanut as StoreCode,
TotalPriceBeforVat,
Time("Time",'hh:mm:ss') as Time,
SalesmanID,
Quantity,
if (Quantity<0,1,0)as 'Return flag'
FROM [lib://DBF/SalesNew.qvd]
(qvd);
Left Join (TempSalesNew)
LOAD
CampaignID,
Name as CampaignName
FROM [lib://DBF/Campaigns.qvd]
(qvd);
NoConcatenate
SalesNew:
LOAD
ItemID,
Date,
CampaignID,
DocumentNumber,
StoreCode,
StoreCode &'|'& ItemID as key,
TotalPriceBeforVat,
"Time",
SalesmanID,
Quantity,
if (Quantity<0,1,0)as 'Return flag',
if(isNull (CampaignName),'No Campaign',CampaignName) as CampaignName
Resident TempSalesNew;
Drop Table TempSalesNew;
/////////////////////////////////////////////////////////////////////////////
SalesNewTEMP:
LOAD
ItemID,
"Date",
CampaignID,
DocumentNumber,
StoreHanut as StoreCode,
TotalPriceBeforVat,
"Time",
SalesmanID,
Quantity
FROM [lib://DBF/SalesNew.qvd]
(qvd);
Left Join(SalesNewTEMP)
load
"Store" as StoreCode,
ItemkeyName as ItemID,
CurrentStockValue/CurrentStock as ItemAlut
FROM [lib://DBF/Stock.qvd]
(qvd);
Left Join(SalesNewTEMP)
load
ItemkeyName as ItemID,
Avg(CurrentStockValue/CurrentStock) as ItemNetworkAlut
FROM [lib://DBF/Stock.qvd]
(qvd)
Group by;
Sales:
LOAD
*,
if(isnull(ItemNetworkAlut),0,
if(Isnull(ItemAlut),ItemNetworkAlut,ItemAlut)) as AlutFinal
resident SalesNewTEMP;
Drop Table SalesNewTEMP;
