topic Re: LOAD in QlikView

LOAD

farolito20 — Thu, 20 Dec 2012 21:33:13 GMT

How Can I load from a specific ID?

For example, from the ID=14?

Re: LOAD

MayilVahanan — Thu, 20 Dec 2012 21:42:16 GMT

Try like this

Load * from tablename where ID = 14;

Re: LOAD

farolito20 — Thu, 20 Dec 2012 21:43:49 GMT

Can be Load * from tablename where ID > 4; but not work

Re: LOAD

CELAMBARASAN — Thu, 20 Dec 2012 21:44:12 GMT

Try this

Load

* From SourceData where ID = 14;

If you are going to use multiple comaprisons

Load

* From SourceData where Match(ID, 14, 12, 10);

Hope it helps

Re: LOAD

CELAMBARASAN — Thu, 20 Dec 2012 21:46:49 GMT

If you need to use Already loaded table then..

Load

Resident

TableName where ID > 4;

Re: LOAD

MayilVahanan — Thu, 20 Dec 2012 21:50:51 GMT

can you say in detail?

Load *;

Select * from Tablename where ID > 4;

Is not working?

Where you are using? Did u load data from xls , sql or any other resource?

Re: LOAD

farolito20 — Thu, 20 Dec 2012 21:51:09 GMT

maximo_registro:

LOAD

max(Checksum) as maximo

from DimCustomers_Day0.qvd (qvd);

load *

from DimCustomers_Day1.qvd (qvd)

where Checksum>$(maximo);

I need de max from the maximo_registro, then use that value to load the other table

Re: LOAD

farolito20 — Thu, 20 Dec 2012 21:51:55 GMT

maximo_registro:

LOAD

max(Checksum) as maximo

from DimCustomers_Day0.qvd (qvd);

load *

from DimCustomers_Day1.qvd (qvd)

where Checksum>$(maximo);

I need de max from the maximo_registro, then use that value to load the other table

Re: LOAD

MayilVahanan — Thu, 20 Dec 2012 21:59:13 GMT

maximo_registro:

LOAD

max(Checksum) as maximo

from DimCustomers_Day0.qvd (qvd);

Let vMax = peek('maximo',0,'maximo_registro');

load *

from DimCustomers_Day1.qvd (qvd)

where Checksum>'$(vMax)';

Re: LOAD

CELAMBARASAN — Thu, 20 Dec 2012 21:59:40 GMT

maximo_registro:

LOAD

max(Checksum) as maximo

from DimCustomers_Day0.qvd (qvd);

LET vMax = FieldValue('maximo', 1);

load *

from DimCustomers_Day1.qvd (qvd)

where Checksum>$(vMax);