Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Dynamically rename column names based on date and formula

nudraco
7 - Meteor

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.

3 REPLIES 3
JordanB
Alteryx
Alteryx

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
7 - Meteor

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
7 - Meteor

Thank you, Jordan!

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

Thank you very much for your help!

Steve.

Labels