Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Exclude first 5 Rows from Excel and LOAD

Hi,

 

I have a large file, But attached the sample file.

 

I want to exclude the first 5 rows and load from 6 row onwards.

ar3asdas 
bfesda 
cr3asdas 
dfeas 
eawas 
COUNTRYSTATEADDRESSZIPPHONE
INDIATAMILNADUChennai70003491999842
USAOKTULSA4324512234567845

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.

Thanks

LKVepuri

2 Solutions

Accepted Solutions
Highlighted
Partner
Partner

hi 

quite easy , when you call the excel file you can set the header size by lines 

look at the image below 

Annotation 2020-04-19 205819.png

View solution in original post

Highlighted
Creator II
Creator II

hi, look this.

 

LOAD COUNTRY,
STATE,
ADDRESS,
ZIP,
PHONE
FROM
[C:\Users\Danilo\Downloads\Sample.xlsx]

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

 

danilostochi_0-1587321261703.png

 

+55(44) 9 9993-3605, WhatsApp
E-Mail or Skype - danilo16stochi@hotmail.com

View solution in original post

3 Replies
Highlighted
Partner
Partner

hi 

quite easy , when you call the excel file you can set the header size by lines 

look at the image below 

Annotation 2020-04-19 205819.png

View solution in original post

Highlighted
Creator II
Creator II

hi, look this.

 

LOAD COUNTRY,
STATE,
ADDRESS,
ZIP,
PHONE
FROM
[C:\Users\Danilo\Downloads\Sample.xlsx]

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

 

danilostochi_0-1587321261703.png

 

+55(44) 9 9993-3605, WhatsApp
E-Mail or Skype - danilo16stochi@hotmail.com

View solution in original post

Highlighted
Specialist III
Specialist III

RecNo() or RowNo() can't be used in Where Clause.

tab1:
LOAD RowNo(),*
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
];