Load Table use 2nd row as columns, ignore 1st row

[Anonymous]

Hi,

i want to load a table. I don´t need the 1st row, because in the 2nd row are the columnames.

How can i load the table, that the 1st row will be ignored?

regards,

sam

[Anonymous]

Try something like :

YourTable:

LOAD * FROM [YourFile]

WHERE RecNo() > 1;

[tomasz_tru · Accepted solution]

If you're loading from a file try use:

LOAD *

FROM [lib://File.xlsx]

(ooxml, embedded labels, header is 1 lines, table is XXX);

[Anonymous]

Perfect, thanks a lot! @bill.markham, too 🙂

regards,

sam