Group By Aggregation Error

[#1]

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

[MK_QSL]

LOAD

     Count(ID) as Counter

Resident A;

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