topic Re: How to omit rows from an imported Excel document in Qlikview in QlikView

How to omit rows from an imported Excel document in Qlikview

Thu, 23 Jun 2016 19:50:32 GMT

Hello,

I am trying to import an Excel document into Qlikview. This Excel document has thousands of rows and rows 1-8 are solely used for titles. So, I want Qlikview to only look at row 9 and beyond. How can I import only rows x >=9?

I've tried:

Directory;
LOAD B,
C,
D,
E,
G,
Y,
AZ,
BB,
BC,
BH,
BI,
FROM
[Source]
(ooxml, explicit labels, table is [Source])

WHERE RowNo() >= 9;

I've also tried:

WHERE (G >= 9) but all this does is only take values in G that are greater than or equal to 9.

So far, neither of these options is working. Any help is greatly appreciated.

Re: How to omit rows from an imported Excel document in Qlikview

trdandamudi — Thu, 23 Jun 2016 20:51:33 GMT

May be as below:

LOAD [Header 9],

ID,

Name

FROM

(ooxml, embedded labels, header is 8 lines, table is Sheet1);

Re: How to omit rows from an imported Excel document in Qlikview

tamilarasu — Fri, 24 Jun 2016 02:07:59 GMT

As mentioned by Thirumala you can use header size in file wizard to load from row 9.

You can alos use below method. (Note: I have used RecNo() function instead of RowNo())

Directory;

LOAD B,

AZ,

BB,

BC,

BH,

BI,

FROM

[Source]

(ooxml, explicit labels, table is [Source])

WHERE RecNo() >= 9;