Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Excel load remove rows

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

3 Replies
Anonymous
Not applicable
Author

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
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Anonymous
Not applicable
Author

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,