Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts ,
I am trying to load data from a table and using group by function but while executing getting invalid expression error. Below is the code snippet :
LOAD [Item SKU],
[Item Status],
Brand,
Month,
Model,
Quarter,
Year,
Division,
Sum([Sales Quantity]) as [Sales Quantity]
FROM
The flat file contains many fields (Key is one of the field) but i want only the above mentioned field's data to be loaded grouped by Key .
Can anybody help here how to overcome this issue .
Please share some sample data...
Try like:
T1:
LOAD
Key,
[Item SKU],
[Item Status],
Brand,
Month,
Model,
Quarter,
Year,
Division
FROM
Join
LOAD
Key,
Sum([Sales Quantity]) as [Sales Quantity]
FROM