Hi
I'm trying to reproduce the logic that can be done in Excel with just 2 simple formulas.
The table is this
Basically Computed WL is
if not isnull([Measured WL]) then
[Measured WL]
else
[Row-1:Freeboard]
endif
And Freeboard is
[Measured WL]*0.95
It's only Semi-Recursive because the input to one row is the output of the previous one. This works in Excel, because Excel ultimately calculates the entire row before proceeding to the next one.
In Alteryx we find ourselves with following situation
This work flow produces this result
Where the Measured WL is null, the Computed WL should be the Freeboard from the row above, like the Excel sheet.
I'm looking for a way to ensure that 2 tools are executed in sequence for each row of data before moving on to the next row
It seems that this "should" be simple to reproduce with built-in tools, but i'm stumped. This may be solved using a macro, but i'm not familiar enough with them to know how to pass in not just the current row, but also the row before.
Any ideas?
P.S. I've also attached the workflow(such as it is) and the excel file
Edit: In talking this over with one of my colleagues, i realized that this simple example can be solved by calculating the Freeboard column first. However, in my real world data, there is no single column that can be calculated before all the others. I still need a way to process the 2 tools for each row before proceeding to the next
Thanks
Dan
