Dynamically rename column names based on date and formula

[nudraco]

Hello Community!

I am the new Alteryx Community memeber - glad to be here.

Here is challenge that I have: 

Current column names in the table like "Field1" (please see atttached excel file).  

How to get to the Future column names like "201608" (please see atttached excel file). ? 

Thank you very much!!

Steve.

[JordanB]

Hi @nudraco

I have attached a workflow built in Alteryx 10.6. 

I create a list of your field headers and fed that into our dynamic rename tool. This tool renames field headers.

I had to hard code the generate rows tool for the dates to match your data, so please take a look at this because depending on if your data is current you could use the datetimenow() calculation to make it dynamic going forward (Additional notes in the workflow).

Best,

Jordan Barker

Solutions Consultant

[nudraco]

Thank you, Jordan!

Appreciate your help.

Let me look at your proposed solution and I'll get back to you with my results. 

Steve.

[nudraco · Accepted solution]

Thank you, Jordan!

Just want to let you know that your solution is working great. 

Thank you very much for your help!

Steve.