Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

homersimpson
Contributor II

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

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

1 Solution

Accepted Solutions
tomasz_tru
Valued Contributor

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

If you're loading from a file try use:

LOAD *

FROM [lib://File.xlsx]

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

3 Replies

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

Try something like :

YourTable:

LOAD * FROM [YourFile]

WHERE RecNo() > 1;

tomasz_tru
Valued Contributor

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

If you're loading from a file try use:

LOAD *

FROM [lib://File.xlsx]

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

homersimpson
Contributor II

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

Perfect, thanks a lot! @bill.markham, too :-)

regards,

sam

Community Browser