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 · Accepted solution]

@shaheer Mention the line number to be imported in the input tool

[Emmanuel_G]

@shaheer 

In attachement one way of doing that.

Just change Start data import on line.

[shaheer]

I had done this for a sample size I was testing with, but the actual file is very large and contains way more data, and for some reason this option does not appear. 

[binuacs]

@shaheer are you using .xlsx file as input?

[shaheer]

This option is unavailable for me for some reason.

[shaheer]

Yes the file type is .xlsx

[binuacs]

@shaheer Can you try the attached file and see you are able to see that option?

[shaheer]

When I press ok nothing appears. 

[binuacs]

@shaheer check your download folder for the workflow