Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
If you're loading from a file try use:
LOAD *
FROM [lib://File.xlsx]
(ooxml, embedded labels, header is 1 lines, table is XXX);
Try something like :
YourTable:
LOAD * FROM [YourFile]
WHERE RecNo() > 1;
If you're loading from a file try use:
LOAD *
FROM [lib://File.xlsx]
(ooxml, embedded labels, header is 1 lines, table is XXX);