This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am new to Alteryx. Playing with it last 4 weeks. Trying to solve the issue explained below. Can’t find anything useful when browsing. I have store ID and date sorted by id and date.
Then my SOS_Input looks like the one below (print screen attached). What I need is to do is: IF [My_ID] == [Row-1:My_ID] take the first non zero value from SOS_input and fill the entire series for this store and all date with this value until new different non zero value will be in SOS_input - desired output my SOS_output.
Here in print screen (below) is the same value couple of times 0.375 till 05/09/2016 when it is 0.386, but it will be easier to see in test file with data attached.
There are 2 sheets in file Smaller with only two different ID and bigger with multiple ids.
Hope my explanation make sense. I was trying to use multi row action, not sure is this is good direction.
I solved the challenge by filtering out the 0 values and then sampling the first record for each store. I then joined the data back together and used a multi-row formula. That formula looks for the highest value of (Input, Previous output and the first Input) and sets that as the output value. Here's the formula: