Alteryx Multi Row Formula Data Transformation

[altrx_guy]

Hi Everyone,

Here is what I am trying to do. The first table you will see is input table whereas what I want to see is the output table

Input Table -   

Letter	Value
A	80
A	80
A	80
A	80
A	63
A	63
A	63
A	80
A	80

 Output Table

Letter	Value	Status
A	80	Before
A	80	Before
A	80	Before
A	80	Before
A	63	During
A	63	During
A	63	During
A	80	After
A	80	After

I want to get the output table (Creating a new column 'Status') from the input table. This is just a sample data. If there is 80 all along, the status should be 'Before'. But if there is a change (as you can see 63 from 80, the status should be 'During' and it should be 'During' as long as it is 63. And when it changes again to 80, the status should be 'After'. There can be many values but the logic should be the same. Please help in this scenario! I think multi-row formula is the best tool to achieve this. You can use as many data points as you want but the goal is clear. Thank you so much!

[Felipe_Ribeir0]

Hi @altrx_guy 

Try this formula inside of your multi-row tool:

IF [Value] != [Row-1:Value] and [Row-1:Value] = Null() 
THEN 'Before' 
ELSEIF [Value] != [Row-1:Value] and [Row-1:Status] = 'Before'
THEN 'During' 
ELSEIF [Value] != [Row-1:Value] and [Row-1:Status] = 'During'
THEN 'After'
ELSEIF [Value] != [Row-1:Value] and [Row-1:Status] = 'After'
THEN 'Before'
ELSE [Row-1:Status]
ENDIF