Discussion Board for collaboration on QlikView Scripting.
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