Hi,
could someone help me?
I have a file that runs from January 4th to January 29th, with working days only.
I need to generate a report that groups the information by Code, by Date column and sums the Value column.
Where I'm struggling is: I also need to generate holidays and weekends (the days generated must replicate the information from the previous days, except when rows generated are first, because there will be no value above to replicate).
I used the Summarize tool to get the minimum and maximum dates and generate the missing dates in between.
However, this way, I was not able to generate the dates before and after the ones I already have in the report.
Input example:
| Date | Code | Value |
| 2021-01-04 | Y | 1 |
| 2021-01-04 | X | 2 |
| 2021-01-04 | X | 3 |
| 2021-01-05 | Y | 1 |
| 2021-01-05 | Y | 1 |
| 2021-01-05 | X | 2 |
| 2021-01-06 | Y | 1 |
| 2021-01-06 | X | 2 |
Desired output:
| Date | Code | Value |
| 2021-01-01 | | |
| 2021-01-02 | | |
| 2021-01-03 | | |
| 2021-01-04 | X | 5 |
| 2021-01-05 | X | 2 |
| 2021-01-06 | X | 2 |
| 2021-01-07 | X | 2 |
| | | |
| 2021-01-01 | | |
| 2021-01-02 | | |
| 2021-01-03 | | |
| 2021-01-04 | Y | 1 |
| 2021-01-05 | Y | 2 |
| 2021-01-06 | Y | 1 |
| 2021-01-07 | Y | 1 |
Is there a way to do this?
Thank you!
