Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?)
LOAD
Count(ID) as Counter
Resident A;
No need of Group By as only single column in Load Statement.