Hi Everyone,
i am new in Alteryx and would like your help for the problem below
onward
0
0
onward
return
0
0
0
return
onward
0
0
i want that for the given problem the rows which are zero should take the nearest value i.e
onward
onward
onward
return
return
return
This is a sample and usually there are 30 to 40 zeroes between two available values.
Solved! Go to Solution.
The multi-row formula is the way to go.
If you want to fill from previous it is very straightforward:
IIF([Field1]='0',[Row-1:Field1],[Field1])
To fill in from next you would need to reverse the order and then use same process and then flip back. While the MultiRow allow look forward it doesn't allow repeatedly walking forward to find value.
If you actually want whichever is 'nearest' that is a more challenging problem
Sample of the first two attached. (If you need the third can put together)
There is a great interactive lesson for you that explains the concept and application well. Please check this out!
https://community.alteryx.com/t5/Interactive-Lessons/How-to-Fill-Your-Data/ta-p/82872
Cheers,
Mark
Thanks :-)
Taking value from the previous cell is currently serving my purpose.