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. 

[binuacs]

@shaheer The above workflows should work in this version. Please let us know your progress.

[shaheer]

@binuacs @Emmanuel_G I've managed to work a way around the issue to get what I need, this is only the sample size but I get the desired result as needed and I am able to skip the rows while using the dynamic rename tool to change the header values. I will be testing with the actual file size momentarily. Thanks for your guys' help btw!

[juan1]

@shaheer The solutions above are the optimal way, you can also do select records and a dynamic rename if for some reason you are not able to do it. 

Select Records: 6-

Dynamic Rename: "Take field names from first row of data"

Hope this helps!