ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
The Alteryx Community will be temporarily unavailable for a time due to scheduled maintenance on Thursday, April 22nd. Please plan accordingly.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Setting N row as header's row

Stanislaw
7 - Meteor

Hello everybody,

 

Let's say I have an Excel file similar to this:

blablalbllbblablabla blaaaa  
bla bla bla blabla bla bla   
DateTeaCoffeeSodaWater
2020/111235781
2020/121533981

 

I'd like to remove the first two rows and set the third one as a header's row.

I managed to use the sample tool and skip 2 rows, but instead of having this:

 

DateTeaCoffeeSodaWater
2020/111235781
2020/121533981

 

I have this:

 

F1F2F3F4F5
DateTeaCoffeeSodaWater
2020/111235781
2020/121533981

 

Why is that?

Could you help me please? Thanks!

afv2688
16 - Nebula
16 - Nebula

Hello @Stanislaw ,

 

go to the developer tools, there you will find one called dynamic rename.

 

On the configuration window select the option 'take field names from first row of data' and you will be done 🙂

 

Untitled.png

 

Regards

Stanislaw
7 - Meteor

Oh my, so easy. Thank you.

I tried the tool before, but saw two inputs and it confused me and I left. 🙂

Labels