4 Replies Latest reply: Apr 2, 2013 6:33 AM by Gysbert Wassenaar RSS

    Group By

      hi,

      I have applied group by as:

       

      A:

      LOAD

           max(ShiftStartDate) as ShiftStartDate,

          max(ShiftEndDate) as ShiftEndDate,

            REF_AgentName,

              REF_acdId

         

      FROM

      D:\Qvd\Employee.qvd

      (qvd) group by  REF_AgentName,REF_acdId;

       

      Now there are more fields also which I want to fetch.

       

      how can I add fields in table A from same qvd.

       

       

      Thnks