In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

How to make the first row into column headers without using Dynamic Rename?

hegdepavithra10
9 - Comet

Hi Alteryx Community ,

 

I have the below data. Is it possible to make the first row as header without using Dynamic Rename tool?

 

hegdepavithra10_0-1603015229772.png

 

hegdepavithra10_1-1603015249163.png

 

5 REPLIES 5
cgoodman
ACE Emeritus
ACE Emeritus

When you read the data in there is a tick box with First Row Contains Data, untick that and it will read the first row as a header.

Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
cgoodman
ACE Emeritus
ACE Emeritus

Or if you want to engineer something then this does the same thing without using the dynamic rename tool.

 

cgoodman3_0-1603016600122.png

 

 

 

Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
Qiu
21 - Polaris
21 - Polaris

@hegdepavithra10 
@cgoodman  Its very interesting to see that the two flow are very similar.キャプチャ123.PNG

cgoodman
ACE Emeritus
ACE Emeritus

Just using the filter tool to do the split instead of first n with a sample tool 😉

Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
philosophy22
7 - Meteor

Really helpful!

Labels
Top Solution Authors