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