topic Re: loading data from xl? in QlikView

loading data from xl?

Wed, 10 Dec 2014 11:18:59 GMT

i want load data from excel but not all records

i want load only specfic records?

how to load specfic records in to qv?

Re: loading data from xl?

arulsettu — Wed, 10 Dec 2014 11:21:45 GMT

hi try this

first 10 load

from ......

Re: loading data from xl?

goncalo_ricardo_pereira — Wed, 10 Dec 2014 11:23:44 GMT

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.

Re: loading data from xl?

datanibbler — Wed, 10 Dec 2014 11:23:54 GMT

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

Re: loading data from xl?

Wed, 10 Dec 2014 11:24:24 GMT

you can use where condition like sql in that.

Re: loading data from xl?

Wed, 10 Dec 2014 11:52:16 GMT

Here i want load odd number records only

what to do for that

Re: loading data from xl?

simenkg — Wed, 10 Dec 2014 11:56:13 GMT

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

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

Re: loading data from xl?

Wed, 10 Dec 2014 11:58:54 GMT

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.

Re: loading data from xl?

goncalo_ricardo_pereira — Wed, 10 Dec 2014 12:02:21 GMT

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.