How to Ignore Certain Rows of Excel Input File

[shaheer]

I have data in a file that looks similar to this:

Company Name	Apple
Total Employees	100
Compensation
Name	Age	Hours	Manager1	Manager2
James	20	40	Annie	Jack
John	25	40	Kuldeep	Jack
Amy	22	40	Arthur	Albert

I want to use the select tool to grab the following columns: Name, Hours, Manager1. However, when I try to use the tool, these headers do not show up and instead I see F1, F2, F3 etc. I want to ignore rows 1-5 and only use data from row 6 onwards, 

I have tried using the "Start Data Import on Line 6" feature in the Input Data tool, but that only worked for a smaller sample size I was testing with. It disappears when I use the larger file I want to work with. 

[shaheer]

It's in my downloads folder but I am unable to open it, possibly because I have an earlier version of alteryx? It also says it is a package, and when I move forward in the steps for opening it, it gives me the error I showed.

[binuacs]

@shaheer Can you share your input file settings

[shaheer]

Are these the settings you are looking for? I am new to alteryx sorry.

[binuacs]

@shaheer Attaching another option

[Emmanuel_G]

@shaheer 

In attachement a way of doing that if you don't have option in input tool.

[shaheer]

It doesn't seem to change anything. 

Even with this tool, the headers appear in the select tool as shown above, rather than their actual names such as Name, Age, etc. 

[shaheer]

I'd previously tried this, didn't work either. I am going to try starting from scratch again, but this time start with the actual file I want to work with and not the sample size.

[binuacs]

@shaheer what is your alteryx version?

[shaheer]

@Emmanuel_G @binuacs So I've started from scratch, and now the option to start the Data Input from line _ is available again. I am going to continue and update you guys soon. 

[shaheer]

2021.2 x64