This content has been marked as final. Show 2 replies
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],
Sum([Sales Quantity]) as [Sales Quantity]
[E:\All Data1.qvd] (qvd) Group By Key ;
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 .