Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Pull the last value from multiple waterfall columns into a new column


Hi all,


I am attempting to build a workflow that takes this data in a "triangle" or waterfall type format into a new column. The aspect I'm struggling with here is that I only need to pull the last value (that's not null or 0) for each column. Lastly, I'm trying to pull the value for the right-most column first, and proceed to the next column on the left for the next value.

Dummy Data Triangles.PNG

I tried using a multi-row formula along with an IF statement: IF [F17] = 0 THEN [Row-1:F17] ELSE [F17] ENDIF ; but I'm getting duplicate values for the multi-row. I considered using nested IF statements as well, but I think that would continue to pull in a singular column's last value (output below; new column trying to fill out is "Cumulative Incurred Losses"). I uploaded a dummy excel file with the input file format. Any guidance would be greatly appreciated. Thank you in advance


Dummy Data WF1.PNG


Hope this helps!




Edit : Updated the correct workflow.


Sample field is a tool I haven't seen utilized/needed to use yet; looks like that was the trick to pulling the last values. Thanks @princejindal !

Glad it helped you. I believe you can also use summarize tool "Groupby" Name and select "Last" for Value.