Alteryx Designer Desktop Discussions

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

use previous value from field until next values comes

Tdalvi
6 - Meteoroid

I am looking a for solution the for below scenario:

Input:

length
 
 
 
 
 
 
2117610
 
 
2117756
 
 
 

 

 

Output:

 

length
0
0
0
0
0
0
2117610
2117610
2117610
2117756
2117756
2117756
2117756
2 REPLIES 2
DataNath
17 - Castor

Hey @Tdalvi - you can use a Multi-Row formula to fill down like that :) workflow attached.

 

DataNath_0-1657272903259.png

 

Tdalvi
6 - Meteoroid

Really Thanks, Working correctly, and my mistake was I wasnt updating in length column. I was creating a new field and because of that, I was getting the wrong values.

 

Really thanks again

Labels