Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
prabhas277
Creator
Creator

loading data from XL

      If I Want to Skip specific rows in Excel during Load how do we need to do that?

7 Replies
sunny_talwar

Maybe something like this:

LOAD *

FROM Excel

Where not Match(RowNo(), 15, 20, 25);

the above code should exclude row number 15, 20 and 25

awhitfield
Partner
Partner

Hi Prabhas,

you can use the Table Files> File Wizard: Transform, this will create the resultant script for you, e.g

HTH

Andy

vsudhakar
Creator III
Creator III

load the excel file and the than write the code where not exits rowno()= give the numbers

vsudhakar
Creator III
Creator III

load the excel file and the than write the code where not exits (rowno(),give the numbers)

prabhas277
Creator
Creator
Author

hi sunny,

my data like this

A     B     C     D

1     2    3      4

5     6     7     8

9     1     2     3

4     5     6     7

i need to skip 3 row only, remaining should be same  please write the code for that @ !

sunny_talwar

Like this:

Table:

LOAD * Inline [

A,     B,    C,     D

1,     2,    3,      4

5,     6,     7,     8

9,     1,     2,     3

4,     5,     6,     7

]

Where RowNo() <> 3;

I am using inline load, but you can do the same for your excel load

Table:

LOAD A,

          B,

          C,

          D

FROM Excel

Where RowNo <> 3;

jyothish8807
Master II
Master II

Hi Prabhas,

There are multiple way to do that.

1. Do you have a primary key in this table ? If yes then you can limit it using a where clause.

2. Else add rowno() in the table and limit according the row number.

eg, Load *

from table.xls

where A<>9;

//amusing A is primary key

2nd option.

Load *,

roeno() as Sino

from table.xls

where not Match(RowNo(), 3);


Regards

KC

Best Regards,
KC