Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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