Invalid expression

AmirKilkr — Sun, 12 Dec 2021 12:38:08 GMT

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;

Re: Invalid expression

MarcoWedel — Sun, 12 Dec 2021 18:51:27 GMT

did you try to comment out parts of the script to narrow down the statement that generates this error (if the error message itself does not point to the right spot)?

Re: Invalid expression

anat — Mon, 13 Dec 2021 04:44:05 GMT

can u check in group by function...

topic Re: Invalid expression in App Development

Invalid expression

Re: Invalid expression

Re: Invalid expression