Filling up table

Question

Hi Everyone

I hope you are all doing great.

I have attached a table that contains Year, Month, Team, Count and Running Total of that count.

I am looking for a way to generate rows to complete the months of the year, continuing also the running total.

For example:

Primary Allocation SO has data for June and July of 2022. I would need to generate rows completing a row for each month of 2022, and 2023, continuing the running total.

I hope this was clarifying.

Thanks a lot for your help. I really appreciate it.

Test Alteryx.xlsx

Yoshiro_Fujimori · Accepted Answer

Hi @Guti1095CG ,

I interpret that you want to add rows for missing months for each [Primary Allocation],

and that [Count] for missing months is always zero.

With these assumptions, here is a potential solution.

Workflow

You may change the range of months in Generate Rows tool if necessary.

Output

The row of 2022/02 is added.