Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Formula showing changes and evolution

sanastasova
7 - Meteor

Hi, 

 

I have a data set containing information about year 2021 and year 2022. The column year 2021 is fixed and is not going to change. However column "Actual "changes with new name every week. I want to create a new column that shows me only the changes. Ex: if I have Silver in column 2021 and it stays silver I don't need it to be shown, but however if silver becomes gold I need it in the data base. Attached also is an example of the data. Thanks a lot !!!

5 REPLIES 5
atcodedog05
22 - Nova
22 - Nova

Hi @sanastasova 

 

You can accommodate it with a filter like the below.

 

atcodedog05_0-1645097101617.png

 

Hope this helps : )

 

atcodedog05
22 - Nova
22 - Nova

Hi @sanastasova 

 

Use a formula tool like below

 

atcodedog05_0-1645097526043.png

 

Hope this helps : )

 

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @sanastasova 

Cheers and have a nice day!

NikyN
9 - Comet

Hello @sanastasova,

 

please find attached solution. 

 

As per table below, you can see on what color in Year 2021 change happened -- if you would like to see only changed items/or not matching ones just apply filter :) 

 

This way you won't have duplications and see what row/columns has been udpated.

NikyN_0-1645098021970.png

 

Best Luck!

 

Niky

sanastasova
7 - Meteor

Thanks a lot for the help and the quick answers !

Labels