Rename of Columns using Dynamic Rename Tool excluding weekends

[sinhsaa]

Below shown is my input table:

Data	Code	25-Sep	26-Sep	27-Sep	28-Sep	29-Sep
a	x	124000000	78000000	78000000	78000000	78000000
b	y	0	-46000000	-46000000	-46000000	-46000000
c	z	8000000	8000000	8000000	8000000	8000000
d	a	6000000	6000000	6000000	6000000	6000000
e	c	40000000	40000000	40000000	40000000	40000000
f	d	70000000	70000000	70000000	70000000	70000000

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.

[binuacs · Accepted solution]

@sinhsaa 
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Dynamic-Rename-Tool-to-Rename-...

[dreldrel · Accepted solution]

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 solution]

@binuacs and myself solved for this type of ask in the thread @binuacs 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