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

how to get column name of left column and update right column with result

Dapo
5 - Atom

 

Please I need help with this

 

Currently my sheet looks like this

June 2021Field 17Field 18July 2021Field 20Field 21
YTDMTDMTDYTDMTDMTD
752362677533643115
344126775353246678
245643772878535744

 

Here's the result I'm hoping for - updating specific column name in respect to the left column

 

June 2021June 2021June 2021July 2021July 2021July 2021
YTDMTDMTDYTDMTDMTD
752362677533643115
344126775353246678
245643772878535744

 

Many thanks

8 REPLIES 8
drew9
9 - Comet

Hi @Dapo , 

 

Unfortunately Alteryx does not support having 2 or more column headers with the exact same name, so we have to get a little crafty. I have attached an example solution here. Hope this sparks some inspiration.

Maskell_Rascal
13 - Pulsar

Hi @Dapo 

 

Alteryx won't allow you to name fields the same. When you try to do this, it will rename each duplicate field with an underscore and number to show the duplicate field names. So the best you could do is rename all your fields like this:

Maskell_Rascal_0-1634136216602.png

 

Let me know if this answers your question. 

 

Cheers!

Phil

atcodedog05
22 - Nova
22 - Nova

Hi @Dapo 

 

Here is how you can do it. I have added to space to name to make them look alike.

Workflow:

atcodedog05_0-1634136300199.png

 

Hope this helps : )

 

Christina_H
14 - Magnetar

As another option, you could shift the month names down into the first row of data and keep generic headers.  You could then e.g. put the data into a table without column headers before rendering out.

Dapo
5 - Atom

Thank you @drew9

Dapo
5 - Atom

Yes it answers my question perfectly, thanks @Maskell_Rascal

Dapo
5 - Atom

Yes it does help - thanks 🙂

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Dapo 

Cheers and have a nice day!

Labels