1 Reply Latest reply: Sep 17, 2015 6:34 AM by Manish Kachhia RSS

    Group By Aggregation Error

      A:

      LOAD ID,

           Product,

           Sales

      FROM

      [Left Join.xlsx]

      (ooxml, embedded labels, table is Sheet1);

       

       

      B:

      LOAD ID,

           Margin,

           Cost

      FROM

      [Left Join.xlsx]

      (ooxml, embedded labels, table is Sheet2);

       

       

      left join(A)

      load *

      Resident B;

      Drop table B;

      //------------------------------------------------------------------------------- Code works till above------------------------

      C:

      LOAD Count(ID) as Counter;

      LOAD ID

           Resident A

           Group By ID;    //( Error: Aggregation expression required by Group By clause. Can anybody explain this?)