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!
