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

loading already existing tables with add load

hi, i would like to load an already existing table but he told me that it doesn't exists.



add load

Max(Status.LASTOCCURRENCE) as oldLASTOCCURRENCE

resident Status;

Status:

SQL SELECT
...

FROM TG01885."REPORTER_STATUS"

where FIRSTOCCURRENCE >= $(OLDLASTOCCURRENCE);

best regards
Ingo Placzek

Tags (2)
2 Replies

loading already existing tables with add load

Hello Ingo,

I may be wrong according to your code sample but you must first load your table and then create a new one loading with "RESIDENT".

Hope that helps.

Not applicable

loading already existing tables with add load

Hi,

if you load the Script, then he saved the actuall version, i wanted only to make an "update" of these data with the help of an timestamp

OLDLASTOCCURENCE is the timestamp from the actually loaded data and i wanted only to load the data with Select where the Firstoccurence timestamp is newer than the oldlastoccurence

Community Browser