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