Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
hi try this
first 10 load
*
from ......
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.
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
you can use where condition like sql in that.
Here i want load odd number records only
what to do for that
Load * from Excel.xls [....]
where mod(RowNo(),2)=1;
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.
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.