Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
lakshmanvepuri
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

Labels (3)
2 Solutions

Accepted Solutions
lironbaram
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

danilostochi
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
lironbaram
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

danilostochi
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

Saravanan_Desingh

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