Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!

Get the date if a cell value change

Highlighted
5 - Atom

Hi Alteryx Community: 

Working on a Issue History Log: I've created the workflow to generate a new column everyday with the point in time status of each issue. 

Column C, Column D, Column E...etc is each daily update that Alteryx created. 

I want to create another column (Column B) that if an issue changes status from day to day, and the new column would be today's date. The problem I encountered is column C, Column D and Column E all have different headers ( the day when daily update was run) and i wonder what's the best way to achieve what i wanted. 

 

Thanks!  

 

Highlighted
12 - Quasar

@coastocoast can you post an example of your desired output? the end result is going to be using a combination of the transpose and multi-row formula tools, but knowing what you're looking for would help.

Highlighted
5 - Atom

Thanks for your suggestion I will update the original post and attach an excel. 

Highlighted
Alteryx Certified Partner

Cell Value Change v2.PNG

Labels