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!
Solved! Go to Solution.
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.