Group By Aggregation Error

Thu, 17 Sep 2015 10:32:14 GMT

LOAD ID,

Product,

Sales

FROM

[Left Join.xlsx]

(ooxml, embedded labels, table is Sheet1);

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

LOAD Count(ID) as Counter;

LOAD ID

Resident A

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

Re: Group By Aggregation Error

MK_QSL — Thu, 17 Sep 2015 10:34:04 GMT

LOAD

Count(ID) as Counter

Resident A;

No need of Group By as only single column in Load Statement.