Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more 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
20 - Arcturus
20 - Arcturus

@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