Append Load, Only load new data

Mon, 09 Nov 2009 20:27:24 GMT

Hi,

I am loading data from a call center and running reports off of it, each new call is logged into a table within an SQL database with a Call ID. At the moment every time the data is reloaded all the data is pulled from the table. I have started to create a append load to only reload "new" data.

How do I specifie to only load new data after the latest time and date previously loaded in the last load?

Here is my current code:


Inbound:
LOAD *
SQL SELECT
FROM Database.Inbound;
CONCATENATE
LOAD * FROM 
(qvd);
STORE Inbound into E://Inbound.qvd;
[\code]
I want to say only load new data stored in the Inbound table in the database which hasnt already been loaded? so take the latest time/date loaded in the last load and load new data written to the database after that?
Hope that makes sence.
Cheers, Joe</body>

Append Load, Only load new data

prieper — Mon, 09 Nov 2009 20:35:44 GMT

Have no code on hand, would suggest

load qvd
determine max Date and relay into a variable
load your data with ...WHERE Date > MyVariable

HTH
Peter

topic Append Load, Only load new data in QlikView

Append Load, Only load new data

Append Load, Only load new data