Inserting a filler row

Question

Hi

I am trying to create a report that shows chemical usage week by week. Most chemicals are used every week but some some aren't, for example, maybe used in week 5 and not used again until week 8. Unfortunately in my source data it doesn't say week 6 and 7 equals zero, there just is no mention of these weeks. I would like to create a row in Alteryx to fill a gap between 5 and 8 that just shows usage as zero. Any suggestions? thanks

Example - this is what I have

Chemical         Week      Usage

Chemical A  -  Week 5   -    9

Chemical A  -  Week 8   -    11

this is what I am trying to create

Chemical         Week      Usage

Chemical A  -  Week 5   -    9

Chemical A  -  Week 6   -    0

Chemical A  -  Week 7   -    0

Chemical A  -  Week 8   -    11

atcodedog05 · Accepted Answer

Hi @BillyL14

Here is how you can do it with help of multi-row formula tool and generate row tool.

Workflow:

Hope this helps : )

Nanoq · Accepted Answer

Here you go, i extended the example data a bit to make sure it can handle multiple entries and chemicals
Let me know if it does what you wanted

vsoni · Accepted Answer

the above solutions are great; if you are working with real dates (versus week 1 week 2 etc.) you can you use the TS Filler tool here, as it is designed for just this scenario.