topic Re: Excel load remove rows in QlikView

Excel load remove rows

Mon, 06 Apr 2015 10:28:37 GMT

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 — Mon, 06 Apr 2015 15:46:37 GMT

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 — Mon, 06 Apr 2015 15:56:27 GMT

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 — Mon, 06 Apr 2015 23:53:21 GMT

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,