Data Changes - Is this Possible inAlteryx ?

[suby]

Hi All,

I have 3 months of sample data  and going forward more data will be added.

Could you please help me to build a workflow which tracks  the Prop Code Changes on month over month Basis.

Say my current reporting period is  30/09/2016.

Three scenarios to execute-

1) New Prop Code  in the current month (30/09/2016.) - compare Prop Code with previous month (if previous don't have=new, else=old)?

2) Prop Code  suspended in the current month (30/09/2016.) -    

3) Prop Code was same - compared to  previous month?       -    

Many Thanks

[suby]

sorry missed your solution 2 workflow with two additional rows of data on my previous update.

[Emil_Kos]

Hi @suby,

So my solution is working for you?

If yes please mark it as accepted. If not please let me know and I will work on it a little bit more. 

[suby]

Hi Emil_Kos,

I am still not getting the expected results and this is what the Input and Output will be let me know if you have some time to find a solution.

[Emil_Kos]

Hi @suby,

I got it:

[Emil_Kos]

Hi @suby,

Did you had a chance to test my soluton?