Alteryx Designer Desktop Discussions

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

Multi Row Formula stop filling down at empty row

45179902
8 - Asteroid

I have a table like this:

123
1  
   
123
1  
   
123
1  

Desired output:

123
123
   
123
123
   
123
123

 

Using Multi Row Formula to fill down the 2's and 3's, how do I make it stop at the blank lines? This is what I'm getting currently:

123
123
 23
123
123
 23
123
123
1 REPLY 1
atcodedog05
22 - Nova
22 - Nova

Hi @45179902 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1642662882877.png

 

Hope this helps : )

 

Labels