topic Re: Need to load the excel by leaving first 20 Rows. in QlikView

Need to load the excel by leaving first 20 Rows.

vinod22kv — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have to load the excel By leaving First 20 Rows, How can i do that....

and the sample excel is attached bellow.

jaumecf23 — Mon, 28 May 2018 13:08:12 GMT

Hi,

Try this:

LOAD no,

name,

[f name],

[last name],

[ph no],

add,

state,

countery,

pin,

company

FROM

[New Microsoft Excel Worksheet.xlsx]

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

shiveshsingh — Mon, 28 May 2018 15:08:52 GMT

May be this

LOAD A, B, C, D, E, F,

G, H, I, J, RowNo() as Row

FROM

[New Microsoft Excel Worksheet.xlsx]

(ooxml, no labels, table is Sheet1);

load A, B, C, D, E, F,

G, H, I, J

Resident T

where Row>20;

drop table T;