topic incremental load in QlikView

incremental load

Anonymous — Thu, 10 Feb 2011 10:53:06 GMT

I Have a Query like this

Select

ID,

Value,

Name

from database

Here i have to implement a incremental load by id. But my incremental load will always fetch only 100 rec from the database since the data volume is too large i need to implement this can any one help me how to set the incremental load with specifice row counts

incremental load

Thu, 10 Feb 2011 10:56:25 GMT

Hello,

Maybe you can try this, after you enter the load statement click on the DEBUG button on the script editor window and then do a Limited Load and type the number of records you want there...I tried this and you can trype number 100 to fetch only 100 records from each table field.

ANDY

incremental load

Thu, 10 Feb 2011 12:18:23 GMT

Hi Narayanan,

If you want to fetch only 100 records then you can use the function "first 100" before your load statement in the table but as you mentioned you want to put incremental load that will fetch only 100 record from your table.Can you tell me on the baisis of what condition you will fetch these 100 records?

Please specifiy how to identify these 100 records.

Regards,

Ravi

incremental load

suniljain — Thu, 10 Feb 2011 12:20:42 GMT

FULL_DATA_TABLE:

Select

ID,

Value,

Name

From Database

concatenate

Load

ID,

Value,

Name

From QVD where not exist(ID);