Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Team,
I have a requirement to show two most recent records for each client , I want to achieve using the expression. How can I do that?
The below Its displaying 4 records for Antonio.With that , I want to see only top 2 records
Thanks
Maybe this can help:
Tab:
LOAD * Inline [
Name , myDate
Antonio , '26.01.2021'
Antonio , '26.03.2021'
Antonio , '26.04.2021'
Antonio , '26.06.2021'
];
newTab:
NoConcatenate LOAD
Name
,max(myDate) as myDate
Resident
Tab
Group by Name;
Concatenate(newTab)
LOAD
Name
,max(myDate, 2) as myDate
Resident
Tab
Group by Name;
drop table Tab;
I want to achieve in the set analysis