Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
@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;
@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;