This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have a large file, But attached the sample file.
I want to exclude the first 5 rows and load from 6 row onwards.
Header should be as follows,
COUNTRY -- STATE -- ADDRESS --- ZIP --- PHONE
I used RecNo() and RowNo() in the where clause but not satisfying my requirement.
I want to take data from 6th ROW onwards.
quite easy , when you call the excel file you can set the header size by lines
look at the image below
View solution in original post
hi, look this.
(ooxml, embedded labels, header is 5 lines, table is Sheet1);
RecNo() or RowNo() can't be used in Where Clause.
Where RowID > 5
LOAD RecNo() As RowID,* INLINE [
F1, F2, F3, F4, F5
a, r3, asd, as,
b, f, e, sda,
c, r3, asd, as,
d, f, e, as,
e, a, w, as,
COUNTRY, STATE, ADDRESS, ZIP, PHONE
INDIA, TAMILNADU, Chennai, 700034, 91999842
USA, OK, TULSA, 43245, 12234567845