Second row as the header name

[kathbanc]

Hi! 

I'm new to alteryx, kindly help your guy here. 

Question : 

I want the second row to be the header ,

OUTPUT

Thank you in advance

[geraldo]

@kathbanc 

if you give more information like if you are reading a file...

[kathbanc]

Hi Goodmorning, 

XLS is the input file. I want the second row from the XLS to be the header name. 

[ShankerV]

Hi @kathbanc 

Please use the below setting in the Input tool while reading the Excel file.

Data's in the Excel file was:

2nd row used as the Header while reading below:

Many thanks

Shanker V

[kathbanc]

Thank you for this, 

this is my workflow,  I use the dynamic input tool, 

The scenario is,  there's a lot of file on the folder, I must select the latest file ( already done) 

the thing is, there is no input tool, since I use the directory and dynamic tool to read the excel file

[ShankerV · Accepted solution]

Hi @kathbanc 

Please do the modification in the Dynamic input tool.

Many thanks

Shanker V

[kathbanc]

It works! thank you so much Shanker!