Can't see the option to "Start Data Import on Line #" in an input data

kimbria7

New to Alteryx, so bear with me here

I added an Input Data item to my workflow to read in an xls file and want to skip the first and third rows, with the header in the second row. So to skip the first row, I was looking for the option/setting within Input Data for "Start Data Import on Line #" but I can't see it. This is what I see:

I was going off this forum post since it's relatively new. Where can I find the setting?

If it matters, I'm running Alteryx Non-Admin Designer Version 2018.4.5.55178

Claje

Hi,

This functionality exists for Microsoft Excel (.xlsx) files, but not for Excel 97-2003 (.xls) files.

If you need to read the file in as a 97-200 .xls file, a method you can use to get to the same output follows:

1) Check off "First Row Contains Data"

2) Add a "Select Records" tool, and configure it as follows:

2
4+

This will filter out rows 1 and 3.

3) Use a Dynamic Rename tool, and choose the Rename mode "Take Field Names from First Row of Data".  This will give you your header information (previously on line 2) as your new column headers.

Hope this helps!