Hi,
We are trying to load data with group by cause.
But wer are getting error as INVALID EXPRESSION.
Below is the script.
Purchase_Orders:
LOAD
Purch.Doc.,
Item,
CoCd,
"Type",
D,
"Created on",
Vendor,
POrg,
PGr,
Crcy,
replace(ltrim(replace(Material, '0', ' ')), ' ', 0) as Material,
Quantity,
OUn,
"Net value",
Business,
"Inventory as of",
'DXR'as Flag
FROM [lib://AttachedFiles/DXR_Open PO's for DXR_7_22_2019.xlsx]
(ooxml, embedded labels, table is Header_PO);
join(Purchase_Orders)
LOAD
Purch.Doc.,
Item,
Schd.,
Deliv.date,
Stat.d.dte,
C,
Sched.qty.,
"GR qty",
// sum(Sched.qty.)-sum("GR qty") as "Open Qty",
sum(Sched.qty.) as sched_QTY,
Issued,
Business,
"Inventory as of",
'DXR'as Flag
FROM [lib://AttachedFiles/DXR_Open PO's for DXR_7_22_2019.xlsx]
(ooxml, embedded labels, table is Detail_PO);
Concatenate(Pruned_Unique)
PO_DXR:
load *
Resident Purchase_Orders group by Material;
Drop Table Purchase_Orders;
Thanks..
