Exclude first 5 Rows from Excel and LOAD

[lakshmanvepuri]

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.

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

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

[lironbaram · Accepted solution]

hi 

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

look at the image below 

[danilostochi · Accepted solution]

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

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