Alteryx Designer Desktop Discussions

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

Row 1 to column header

mark007
8 - Asteroid

Hi all - I am working on one of the weekly challenges, challenging in itself but I'm there... or almost.  

 

I have the attached output and all I need to do is move the 1st row to become a column header.  I can export to excel, reimport and use the settings in the input tool but surely there is a better, less messy, solution?!

 

Thanks all!

 

Mark  

 

mark007_0-1654962893840.png

 

5 REPLIES 5
IraWatt
17 - Castor
17 - Castor

Hey @mark007,

All you need is the dynamic rename tool and just select take field names from first row ðŸ˜„

IraWatt_0-1654963070622.png

 

Adrian_T
Alteryx Alumni (Retired)

Hey @mark007, here's a great resource on learning about the Dynamic Rename Tool. ðŸ˜Ž

 

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Dynamic-Rename/ta-p/32...

mark007
8 - Asteroid

Thanks @IraWatt @Adrian_T - how did I not know that tool existed!

 

Have a great weekend!

IraWatt
17 - Castor
17 - Castor

No worries @mark007 ! have a good one too ! ðŸ˜„

kh9362003
5 - Atom

FYI this post just saved my life. I am so happy I found this and it worked like a charm!!

Labels
Top Solution Authors