Rename of Columns using Dynamic Rename Tool excluding weekends

Question

Below shown is my input table:

DataCode25-Sep26-Sep27-Sep28-Sep29-Sepax12400000078000000780000007800000078000000by0-46000000-46000000-46000000-46000000cz80000008000000800000080000008000000da60000006000000600000060000006000000ec4000000040000000400000004000000040000000fd7000000070000000700000007000000070000000

Desired Output:  Using Dynamic Rename tool, I want today's date to be renamed as T0, and consecutive days as T1, T2 and so on. Need to ensure that weekend in excluded.  Also if I want to rename it back as date format aftersome steps like orignal date, what do I need to do.

binu_acs · Accepted Answer

@sinhsaa 
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Dynamic-Rename-Tool-to-Rename-columns-with-today-s-and-tomorrow/m-p/1413586#M350306

dreldrel · Accepted Answer

You could create a dynamic reference table by a formula tool, starting from your start date on one column and your prefered column name on the other one. After that you can use dynamic renaming tool to update your columns. If this helps, feel free to like the comments

jrlindem · Accepted Answer

@binu_acs and myself solved for this type of ask in the thread @binu_acs linked to above.  Please review that thread and see if that gets you where you need to be.  Reach back out if you need further support.

-Jay