Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey!
How can I load specific rows from an excel dataset, like for example rows 10 to 15?
Best regards
Something like this?
LOAD A
FROM
Excel.xlsx
(ooxml, no labels, table is Sheet1)
where RecNo()>=10 AND RecNo()<=15
;
Something like this?
LOAD A
FROM
Excel.xlsx
(ooxml, no labels, table is Sheet1)
where RecNo()>=10 AND RecNo()<=15
;