Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Dealing with "Month" column headers with rolling 3-month data

arjunt1217
6 - Meteoroid

Sorry for the confusing title, i am not sure how to phrase it succinctly.

 

Attached is my workflow and sample data. 

 

I have data showing the past 10 clients and their transaction volume over the past 3 months. My goal right now is to create a table showing the top 3 clients by volume each month. In my workflow you can see i have achieved that.

 

The problem is with the month column. This data is live and next month instead of May, Jun, Jul data i will have Jun, Jul, Aug data. At this point i believe my workflow will throw an error because the select tool looking for the "May" column will not find it. 

 

I would like to rename the column headers to be "T-1", "T-2", "T-3" so that each month as data updates my workflow will continue to run. The only way i know how to rename the columns is with the select tool, but then we will run into the same error. I believe the dynamic rename tool might by the key though i am not sure how to use it.

 

Any help would be appreciated. Please let me know if you need any more info from me!

2 REPLIES 2
jbichachi003
9 - Comet

It's hard to tell how you image the output to look, but I think this does what you want and it doesn't reference any of the month names.

arjunt1217
6 - Meteoroid

Thank you this works. You are right the output is not too important to me so long as i am able to visualize it appropriately in tableau and i can with your workflow.

Labels