Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Need some help with creating date intervals.
Data:
The result wanted:
The example attached.
Thank you in advance!
Check attached app, need to create a flag in script
what is the logic here?
Try this way
Table:
LOAD * INLINE [
A, F2, Date
A, 1, 2017.01.01
A, 1, 2017.01.02
A, 1, 2017.01.03
A, 2, 2017.01.04
A, 1, 2017.01.05
A, 1, 2017.01.06
B, 3, 2017.01.01
B, 4, 2017.01.02
];
Left Join(Table)
LOAD
F2,
Max(Date) as Maxdate,
Min(Date) as MinDate
Resident Table
Group By F2;
Same fields A and F2 need to have aggregated min and max values.
The order of the Date is critical here.
Rows 2-3-4 and 6-7 have the same data A 1 but according to the Date field there have to be different Min and Max dates.
Unfortunately, this model cannot be applied as we have data like this:
Check attached app, need to create a flag in script
Ok but how you differentiate the 6,7 rows that has values same but different dates in this case max will be 2001.01.06 and min 2017.01.01.
I was so stuck with solving this issue in back end that I have forgotten an easy front end solution.
Thank you!