Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

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
cgoodman3
14 - Magnetar
14 - Magnetar

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
cgoodman3
14 - Magnetar
14 - Magnetar

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 
@cgoodman3  Its very interesting to see that the two flow are very similar.キャプチャ123.PNG

cgoodman3
14 - Magnetar
14 - Magnetar

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