Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

please help with incremental load

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

Tags (2)
Community Browser