Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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