We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

empty rows for running total

terrellchong
8 - Asteroid

I have a set of data that i would like to make some rows for the empty quarter. I had attached an example input and output for reference.

 

3 REPLIES 3
Luke_C
17 - Castor
17 - Castor

Hi @terrellchong 

 

Did you try the generate rows tool? 

 

I created a record for each value between the min/max of the 2nd column in your data. Then appended the ones that didn't already have data and set them to 0

 

Luke_C_0-1652280669287.png

 

MatthewBr
Alteryx Alumni (Retired)

Maybe not the most efficient but you can do something like this...

 

 

MatthewBr
Alteryx Alumni (Retired)

Definitely need to leverage the GENERATE ROWS tool

Labels
Top Solution Authors