We're excited to announce that we'll be partnering with Credly starting October 19th - see what this means and read the announcement blog here!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Inserting a filler row

BillyL14
8 - Asteroid

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

3 REPLIES 3
atcodedog05
20 - Arcturus

Hi @BillyL14 

 

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

Workflow:

atcodedog05_0-1634206703926.png

 

Hope this helps : )

Nanoq
8 - Asteroid

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
Alteryx
Alteryx

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.

vsoni_0-1634215520518.png

 

Labels