Excel load remove rows

[#1]

Hello,

could someone help me, please with a remove rows issue?

I want to load just 5 rows between 5 and 10 lines, but when i use a wizard and make a line like

Remove(Row, RowCnd(Interval, Pos(Top, 10), Pos(Top, 5), Select(1, 0)))

qlik loads  all lines inspite=(

Thanks in advance

[Anonymous]

First make header size 5 line (as required) then use

Remove(Row, RowCnd(Interval, Pos(Top, 5), Pos(Bottom, 1), Select(1, 0)))

));

label should be explicit.

it should work .

Thanks BKC

[jonathandienst]

Hi

Use a "header" directive to skip the first 5 rows, and a "first" to load only 5 lines. Like this:

First 5 LOAD A

FROM

[Test Folder\Test20Rows.xlsx]

(ooxml, no labels, header is 5 lines, table is Sheet1);

HTH

Jonathan

[Anonymous]

In case you want to retain/use the column labels from the spreadsheet, put below condition  in the where clause in addition first 5 load,

where rowno()<=10;

Thanks,