Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
Free Trial

Alteryx Designer Desktop Discussions

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

Dynamically update the null values until nonnull values.

Sarav_93
6 - Meteoroid

Index Currency new_field

0.3 AUD Null

1 AUD 0.043

60 AUD 0.040

72 AUD Null

84 AUD Null

96 AUD Null

108 AUD 0.0426

 

replace the values for nulls to Row+1 values.

for ex: index 72,84,96 has null values in new_field, has to replace the index vlaue of 108 has 0.0426 has new_field value. similarly for 0.3 index has to replace row+1 has 0.043

1 REPLY 1
cjaneczko
13 - Pulsar

Here is one way to do it. 

 

image.pngimage.png

Labels
Top Solution Authors