Data Changes - Is this Possible inAlteryx ?

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.

Solutionv3.yxmd

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

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,

Did you had a chance to test my soluton?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703