Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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