We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to change column header name to todays date

Anjankumar2021
8 - Asteroid

How to change column header name to todays date in Basic table. i tried to change through dynamic rename tool by Appling formula (IIF([_CurrentField_] ='T0', datetimeformat(DateTimeToday(),"%d-%b"),[_CurrentField_]))in output anchor i can see T0 changed to todays date (20-Feb) but in output through render tool its giving only T0.

Pls assist.

 

Anjankumar2021_2-1676873695636.png

 

 

 

Anjankumar2021_0-1676873419278.png

 

4 REPLIES 4
binuacs
21 - Polaris

@Anjankumar2021 One way of doing this with the dynamic rename tool

binuacs_0-1676877814242.png

 

Anjankumar2021
8 - Asteroid

Change column header name to todays date in Basic table. i tried to change through dynamic rename tool by Appling formula (IIF([_CurrentField_] ='T0', datetimeformat(DateTimeToday(),"%d-%b"),[_CurrentField_]))in output anchor i can see T0 changed to todays date (20-Feb) but in output through render tool its giving only T0.

Anjankumar2021
8 - Asteroid

change column header name to todays date in Basic table. i tried to change through dynamic rename tool by Appling formula (IIF([_CurrentField_] ='T0', datetimeformat(DateTimeToday(),"%d-%b"),[_CurrentField_]))in output anchor i can see T0 changed to todays date (20-Feb) but in output through render tool its giving only T0.

binuacs
21 - Polaris

@Anjankumar2021 The dynamic rename should connect before the table tool, and the output of the dynamic tool should be connected to the table tool

 

binuacs_0-1676884734775.png

 

Labels
Top Solution Authors