Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to load rows 1 to 10 and 21 to 30 from an excel table, but not 11-20 and everything above 30.
I use Where Recno<=10 in load script,
but how to load rows 21-30 in the same time?
Thanks in advance !
Something like this should satisfy both your conditions:
YourTable:
LOAD *
FROM
$(Path)
(ooxml, embedded labels, table is Sheet1)
where
RecNo()>=1 and RecNo()<=10 or
RecNo()>=21 and RecNo()<30;
Table:
Load
Filedname,
recno()
from sourcetable;
Final:
Load
Filedname,
recno()
resident Table where recno<=10 and Recno>20;
I think you can use recno with and or
:
LOAD @1, @2, @3
FROM [1.xls] (biff, no labels, table is Sheet1$)
where RecNo() <= 10 or (RecNo() >= 21 and Recno() <=30)
;
Something like this should satisfy both your conditions:
YourTable:
LOAD *
FROM
$(Path)
(ooxml, embedded labels, table is Sheet1)
where
RecNo()>=1 and RecNo()<=10 or
RecNo()>=21 and RecNo()<30;