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
Solved! Go to 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 : )
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 @Nanoq @atcodedog05 thanks everyone, I am working on incorporating this in to my workflow
@vsoni @Nanoq @atcodedog05 thanks all, figured it out
Happy to help : ) @BillyL14
Cheers and have a nice day!