Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

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
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
Top Solution Authors