Create field names from row

[robertcox87]

I am using Alteryx to read a sheet from an Excel file and the column headers are on the 5th row of the spreadsheet.  Is there a way to create column headers from this row?  Thanks in advance!

[markcurry · Accepted solution]

Hi @robertcox87 

You can either change your Input tool for Excel file to set 'Start Data on Import Line' = 5, order you can use the Dynamic Rename tool to take headers from the first line of data.  See attached sample.

[mihaicom20]

Hello,

On Input Date Tool you have the option to start importing the data from a specific row.

I hope this helps you. 

[Maskell_Rascal · Accepted solution]

Hi @robertcox87 

Start your import on line 6. This will make line 5 your headers.