Free Trial

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
Top Solution Authors