In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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