Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be as below:
LOAD [Header 9],
ID,
Name
FROM
(ooxml, embedded labels, header is 8 lines, table is Sheet1);
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,
C,
D,
E,
G,
Y,
AZ,
BB,
BC,
BH,
BI,
FROM
[Source]
(ooxml, explicit labels, table is [Source])
WHERE RecNo() >= 9;