community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More

Multi Row Formula Dealing with Null Values - Grouped by Unique ID

Highlighted
Meteoroid

Scenario: I need to take the most recent year and back fill termination dates for the prior years of data. See Example: 

 

Multi Row Formula.png

 

the 2017-03-27 term date needs to be filled in the Null Gap between the 2015-04-02 and 2017-03-27 term dates. Then the 2015-04-02 term date needs to be filled all the way down for the remaining Null gaps. I have tried using a multi row formula but can't seem to figure it out. 

 

all of the dates are grouped by the same unique ID and cascade down from 2017-2007 years. 

 

PLEASE HELP!!!!!

Alteryx Certified Partner

Hey @tomunger848

 

Try sorting your data first so that the termination date is the first record then multirow formula is easy.

 

You can also use the summarize tool and a join to achieve a similar answer

 

sort.PNG

As there are lots of ways to skin a cat in Alteryx, thought would suggest an alternate.

 

Assuming the termination data you need is on the last record try:

 2018-10-11_15-42-25.png 

The sample tool picks the last record for each unique id. Then join back to original and replace the termination date.

 

 

Labels