Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.
SOLVED

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

Highlighted

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!

Alteryx Partner

@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
Highlighted

You're the man Aaron!

Labels