Row 1 to column header

[mark007]

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  

[IraWatt · Accepted solution]

Hey @mark007,

All you need is the dynamic rename tool and just select take field names from first row 😄

[Adrian_T · Accepted solution]

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]

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

Have a great weekend!

[IraWatt]

No worries @mark007 ! have a good one too ! 😄

[kh9362003]

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

[dnadarajah1]

You can achieve the same by configuring the input data tool, you do not need another tool (Which can slow down the speed)

On the input data tool: 

at 6. First Row Contains Data: <Uncheck this>

at 7. Start Data Import on Line: <Select the line number>