date interval

[Nextle]

Hello.there is a date_start and date_end of one row and a second. If one interval is larger than the other, the result is the row with the largest interval. please help me

result:

thank you in advance.

[MayilVahanan]

Hi 

Try with firstsortedvalue function something like below

Temp2:
Load * Inline
[
ID, Date_Start, Date_End
66, 22.03.2021, 03.04.2021
70, 28.03.2021, 30.03.2021
];

Inner Join
Load FirstSortedValue(ID, Interval(Date_Start-Date_End)) as ID Resident Temp2;