loading data from xl?

[#1]

Hi

i want load data from excel but not all records

i want load only specfic records?

how to load specfic records in to qv?

[arulsettu]

hi try this

first 10 load

*

from ......

[goncalo_ricardo_pereira]

Hello,

You can do something like this:

TableExcel:

LOAD

          Field_1,

          Field_2,

          Field_3,

          Field_4

FROM

(biff, embedded labels, table is Sheet1$)

where Field_1 = 'AnyValue';

Best Regards.

[datanibbler]

Hi,

you have to identify something that is different in the records that you want to load from those that you don't want. There has to be something systematic. Then I'm sure there is a way to define this in QlikView.

HTH

Best regards,

DataNibbler

[#5]

you can use where condition like sql in that.

[#6]

Here i want load odd number records only

what to do for that

[simenkg · Accepted solution]

Load * from Excel.xls [....]

where mod(RowNo(),2)=1;

[#8]

use MOD( <fieldName>, 2) in where clause of load.

if you want to load odd records then use RecNo() 0r RowNo() to get the record number.

[goncalo_ricardo_pereira]

You can use in the where clause the follow qlikview function:

odd(n)

Returns true if n is an odd integer, false if n is an even integer and NULL if n is not an integer.

Examples:

odd( 3 ) returns true

odd( 2 * 10 ) returns false

odd( 3.14 ) returns NULL

Best Regards.