topic Re: Exclude first 5 Rows from Excel and LOAD in QlikView

Exclude first 5 Rows from Excel and LOAD

lakshmanvepuri — Sat, 16 Nov 2024 18:46:01 GMT

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

Re: Exclude first 5 Rows from Excel and LOAD

lironbaram — Sun, 19 Apr 2020 18:00:11 GMT

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

look at the image below

Re: Exclude first 5 Rows from Excel and LOAD

danilostochi — Sun, 19 Apr 2020 18:34:50 GMT

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

Re: Exclude first 5 Rows from Excel and LOAD

Saravanan_Desingh — Sun, 26 Apr 2020 18:36:48 GMT

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