Start Free Trial

Alteryx Designer Desktop Discussions

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

Change month headers.

neromerob
10 - Fireball

Good morning. 

 

I Write because I need a solution to the following problem. I have headers that I need to transforms. 

 

headers..jpg

I mean I know how to change the format of the second headers into the first and vice versa but don´t know which between the two is better for making the change that I Need. 

 

Than you.

 

 

 

5 REPLIES 5
IraWatt
17 - Castor
17 - Castor

Hey @neromerob,

This could probably be all done in one tool with a formula but here is an easier to understand more verbose way:

IraWatt_0-1654616408149.png

Any questions or issues please ask :)
HTH!
Ira

SPetrie
13 - Pulsar

I would use a field info tool to grab all the headers, split it out using a text to columns looking for the underscore, and then format it. You can then use a dynamic rename to replace the old with the new.

SPetrie_0-1654616363324.png

SPetrie_1-1654616391564.png

SPetrie_2-1654616429444.png

 

 

 

binu_acs
21 - Polaris

@neromerob one way of doing this the the dynamic rename tool

 

binuacs_0-1654617404667.png

 

binu_acs
21 - Polaris

@neromerob This workflow is for the second format

 

binuacs_1-1654617634799.png

 

neromerob
10 - Fireball

thank you for the solution, it worked

Labels
Top Solution Authors