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

[Emil_Kos]

Hi @suby,

I have prepared a solution for you

The output:

The truth is I am not sure if catch your message correctly but I hope I got everything right.

[suby]

Hello,

Thanks Can you please post the workflow.

Many Thanks

[Emil_Kos]

Hi @suby,

Please see attached. 

[suby]

Hello,

Thank you so much for the workflow.

Just to get this right -I'm  expecting the below output -

The Prop Code that was highlighted in Blue was there in previous Month but not in current month ( The missing Prop code should be reported in the current month is where I'm facing the challenge)

[Emil_Kos]

Hi @suby,

I have prepared a solution for you:

[suby]

Hi Emil,

Much appreciate it

Thanks for your workflow and I'm getting there but could you please explain why we hard code on  (_Max_Date-1) column for -33 days ?  I don't  want to hard code the dates and this has to more dynamic.

_Max_Date-1

DateTimeAdd([_Max_Date],-33,'day')

Can this flow be dynamic when we add more data.?

[suby]

Hello,

I'm still getting some nulls on the Status Column ? would you mind if you can help and for all the rows i  would expect  any of these values on the status column 

Prop Code same as Previous Month
Prop Code New this Month
Prop Code was in Previous Month but removed in this Month

Also this has to dynamic

when i filter on my Output for the current month (30/10/2016) it  has to compare and populate all those above 3 values  in Status column 

30/10/2016 vs  30/09/2016 

when i filter on my Output for the current month (30/09/2016) has to compare and populate all those above 3 values  in Status column
30/09/2016 vs  31/08/2016

when i filter on my Output for the current month (31/08/2016) has to compare and populate all those above 3 values  in Status column

31/08/2016 vs 31/07/2016

[Emil_Kos]

Hi @suby,

I took 33 days as I wanted to make sure that it will always catch the last working day of the previous month. 

the solution should always check the newest month in the data and it it is taking into consideration the previous month and the newest month.

Please take a look if it is working as expected. 

[suby]

Hi Emil_Kos,

Your solution 2 was close to my requirement but the only thing is i was not getting my desired output.

So on this

 - I have included two extra rows of data for testing.

-  Your solution 2 file attached with extra 2 rows of Data.

My Input and Desired Output as below.

Many Thanks