Second row as the header name

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

Accepted answers

Please do the modification in the Dynamic input tool.

Many thanks

Shanker V

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

Hi Goodmorning,

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

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

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

It works! thank you so much Shanker!