LOAD with GROUP BY with MAX

[qliknonsense]

Hey guys,

I have a problem with a load with group by:

LOAD

Year,

Month,

A,

max(B)

RESIDENT SomeOtherTable

GROUP BY Year, Month;

I want to group by Year and Month, and I want my A to show only in a case where B=max(B).

How can I achieve this?

[Kushal_Chawda · Accepted solution]

@qliknonsense  try below

SomeOtherTable:
LOAD
Year,
Month,
B
FROM table;

inner join(SomeOtherTable)
LOAD
Year,
Month,
max(B) as B
RESIDENT SomeOtherTable
GROUP BY Year,Month;