cells in row taking the next available non zero value in a column

[eamritraz]

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.

[jdunkerley79 · Accepted 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)

[MarqueeCrew]

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

[eamritraz]

Thanks :-)

Taking value from the previous cell is currently serving my purpose.