Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I read in a number of entries, each with 3 Dates: Date_1, Date_2, Date_3. Each date is the Thursday of a week.
Now I would need to display a dynamicly extending(?) table showing the 3 dates AND
In between these dates extend the displayed table with more rows, one for each "missing week":
E.g. when I read in
Date_1 = 2015-08-06
Date_2 = 2015-08-20
Date_3 = 2015-08-27
I would need to display a table like:
Date_1 = 2015-08-06
Date_1+1 = 2015-08-13
Date_2 = 2015-08-20
Date_3 = 2015-08-27
If 2 weeks or 4 weeks are missing in between 2 dates, I need to add these 4 lines...
Can anyone help?
Thanks & Best regards
Oliver
Hi,
one solution could be:
table1:
LOAD * INLINE [
Date
2015-08-06
2015-08-20
2015-08-27
2015-09-17
2015-10-08
];
LOAD Date(Date+IterNo()*7) as Date
While Date+IterNo()*7 < PreviousDate;
LOAD *, Previous(Date) as PreviousDate
Resident table1
Order By Date desc;
hope this helps
regards
Marco