Need to load the excel by leaving first 20 Rows.

[vinod22kv]

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 · Accepted solution]

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]

May be this

T:

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

F:

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

     G, H, I, J

Resident T

where Row>20;

drop table T;