LOAD

[farolito20]

How Can I load from a specific ID?

For example, from the ID=14?

[MayilVahanan]

HI

Try like this

Load * from tablename where ID = 14;

[farolito20]

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

[CELAMBARASAN]

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

[CELAMBARASAN]

If you need to use Already loaded table then..

Load

*

Resident

TableName where ID > 4;

[MayilVahanan]

HI

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?

[farolito20]

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

[farolito20]

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

[MayilVahanan · Accepted solution]

HI

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)';

[CELAMBARASAN]

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);