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!
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.
Start your import on line 6. This will make line 5 your headers.
Hello,
On Input Date Tool you have the option to start importing the data from a specific row.
I hope this helps you.
