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.

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


I have the following dataset


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


to look like this 



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:

multi row.PNG

You're the man Aaron!