2 Replies Latest reply: Apr 19, 2017 1:07 AM by Tresesco B RSS

    Invalid Expression error

    Samir Bihari

      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

      [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 .