Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a below task where i need to allocate or fill the values for the dates,where ther is no data availble in the excel,
I have generated the dates in using master calender ,but not sure how do i assign those values to those dates .Below is my scenario.
Data i have as below:
Activity | Start Date | End date |
A | 1/1/2021 | 3/1/2021 |
D | 4/1/2021 | 6/1/2021 |
F | 7/1/2012 | 9/1/2021 |
Result I required:
Activity | Date | Start Date | End date |
A | 1/1/2021 | 1/1/2021 | 3/1/2021 |
A | 2/1/2021 | ||
A | 3/1/2021 | ||
D | 4/1/2021 | 4/1/2021 | 6/1/2021 |
D | 5/1/2021 | ||
D | 6/1/2021 | ||
F | 7/1/2012 | 4/1/2021 | 9/1/2021 |
F | 8/1/2012 | ||
F | 9/1/2012 |
How i get this column date with respect to activity start date and end date,Please help if any ideas.
Load Activity,
If(IterNo()=1, "Start Date") as "Start Date",
If(IterNo()=1, "End Date") as "End Date",
Date("Start Date"+IterNo()-1) as Date
While "Start Date"+IterNo()-1<="End Date";
Load * Inline [
Activity, Start Date, End Date
A, 1/1/2021, 3/1/2021
D, 4/1/2021, 6/1/2021
F, 7/1/2021, 9/1/2021]