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

Alteryx Designer Desktop Discussions

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

How to fill down with last non null value above in a field?

colestauss
5 - Atom

I have the following dataset

colestauss_1-1581097495541.png

and I want to fill the empty cells (they're null in alteryx) with the last date value from above

 

to look like this 

colestauss_0-1581097418039.png

 

I have found answers on how to fill if the amount of gaps between dates are fixed(multi-row formula grab from above), but what about when they are variable?

 

Thanks for the help!

3 REPLIES 3
Aaron_Harter
11 - Bolide

@colestauss - check out the first example of the Multi-Row Formula tool, which will dynamically fill down from above (from top to bottom) until the end of the data set:

Spoiler
multi row.PNG
colestauss
5 - Atom

You're the man Aaron!

Ashutosh
6 - Meteoroid

Your Question served my purpose

Labels