Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
RÉSOLU

use previous value from field until next values comes

Tdalvi
Météoroïde

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 RÉPONSES 2
DataNath
Castor

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

 

DataNath_0-1657272903259.png

 

Tdalvi
Météoroïde

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

Étiquettes