please help with incremental load

Mon, 19 Sep 2011 07:55:59 GMT

Hello, after some searches on the forum I did found some scripts that made it possible to do an incremental load, but I always get stuck on one way or the other

Background info :

QV Version 10 SR3

Database = MS SQL

Code :

LOAD 
    Email,
    FirstName,
    ModifyDate,
    ModifyKind,
    Name,
    PersonelId,
    PersonelPicture,
    Picture,
    SearchName; 
SQL SELECT * FROM Dehaan.dbo.Personel;

I need to INSERT and UPDATE records, which I should be able to do because I have the field 'ModifyDate' and 'ModifyKind' in all of my SQL-tables. The field 'PersonelId' is the unique key in this table.

Fieldinfo :

'ModifyDate' is structured like : YYYY-MM-DD hh:mm:ss.milisec

'ModifyKind' is : Insert, Modify, Delete (it stays I until changed)

Question :

Could somone please give me the script to do an incremental load ? I'll make the 84 others 🙂

Jochen

PS : Yes I know the STORE command isn't in the provided code

topic please help with incremental load in QlikView

please help with incremental load