Alteryx Designer Desktop Discussions

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

Changing field name

aakanksha_garg
6 - Meteoroid

Hi

I want to change field name of a column which is a date in format YYYYMMDD to a string "Date" using dynamic rename formula tool. Can somebody help me with this. Below is a example of the data i have and the result i want

20220106
20220106

 

Result

Date
20220106

 

Also it will be helpfull if someone can explain in simple terms how is dynamic renaming different from renaming using select tool in this example.

Thannk You in advance!

4 REPLIES 4
atcodedog05
22 - Nova
22 - Nova

Hi @aakanksha_garg 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1645006660776.png

 

Hope this helps : )

 

aakanksha_garg
6 - Meteoroid

What if i want to change date format then i have to use formula tool?

atcodedog05
22 - Nova
22 - Nova

Hi @aakanksha_garg 

 

Yes, you should be able to use it.

 

Hope this helps : )

 

 

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @aakanksha_garg 

Cheers and have a nice day!

Labels