Create month column for empty cells

[pfmd86]

Hi, I have an input table I am pivoting. After the pivot, my result table looks as follows:
| Type | 1/2023 | 5/2023 | 6/2023 |
| SRV | 3 | 11 | 1 |

How can I fill up the missing moths (2,3 and 4) on my table? I also want columns for months that do not have a value (or better, a zero). Any idea how to do it (not manually, since the flow can run with other settings)?

[armingrudd]

Hi @pfmd86,

I think you can add the missing months before pivoting. If possible, would you provide an example workflow which demonstrates what you are trying achieve?

[Daniel_Weikert]

@pfmd86
Create datetime range node to have all dates, join to your orgininal table then do your pivoting
br

[pfmd86]

@armingrudd Thanks for the idea. The thing is, the dates are not fixed. The flow has a configuration of a start and end date. So, it’s flexible.

@Daniel_Weikert I tried. But I’m unsure how to get a flexible range between a variable start and end date.

[pfmd86]

Never mind, I found a solution.

I forgot I can get the number of days between start and end date and use this as a variable for the Create Date&Time Range interval setting.