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.
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!

2 REPLIES 2
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