Where has the start import from Line x gone?

[craigja]

Im importing and XLS file and the headers are in row 2 - on 2021.4 I don thave the option to select the line number to start importing data from...

[IraWatt · Accepted solution]

Hey @craigja,

It is probably because the version of excel its reading is from 1997-2003. You can use the sample tool to skip the first row then use a dynamic rename tool to replace the headers with the top row of data.

[craigja]

Yeah just done that and it works fine, just thought I was missing a trick!

[IraWatt]

Here's an example workflow of how to do this:

[IraWatt]

ah nice ! glad you got it working @craigja :)