Inserting a filler row

[BillyL14]

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 solution]

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 solution]

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 solution]

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.

[BillyL14]

@vsoni @Nanoq @atcodedog05 thanks everyone, I am working on incorporating this in to my workflow

[BillyL14]

@vsoni @Nanoq @atcodedog05  thanks all, figured it out

[atcodedog05]

Happy to help : ) @BillyL14 

Cheers and have a nice day!