Row 1 to column header

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

Workflow

Output

Tips and Tricks

Transformation

Accepted answers

IraWatt

Hey @mark007,

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

Adrian_T

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/32920

All comments

IraWatt

Hey @mark007,

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

Adrian_T

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/32920

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>

JBO

@dnadarajah1 my headers are at row 18 and my data starts on row 19. I attempted using the input data tool by setting setting Start Data Import on Line to 18 and unchecking the First Row Contains Data box. Is there some easy way to tell it that my headers are at Row 18? Thanks!

JBO

@dnadarajah1 Disregard. I feel dumb. I just needed to set it to Row 19 instead of 18 and the headers appeared. Duh.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280