How to load limited rows from Excel

[#1]

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 !

[#2]

Table:

Load

        Filedname,

        recno()

from sourcetable;

Final:

Load

        Filedname,

        recno()

resident Table where recno<=10 and Recno>20;

[maxgro]

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)

;

[mjayachandran · Accepted solution]

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;