Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
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

Re: Exclude first 5 Rows from Excel and LOAD

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

Re: Exclude first 5 Rows from Excel and LOAD

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

Re: Exclude first 5 Rows from Excel and LOAD

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

Re: Exclude first 5 Rows from Excel and LOAD

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

Re: Exclude first 5 Rows from Excel and LOAD

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
];