topic loading already existing tables with add load in QlikView

loading already existing tables with add load

Wed, 16 Jun 2010 14:09:08 GMT

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

loading already existing tables with add load

Miguel_Angel_Baeyens — Wed, 16 Jun 2010 14:16:00 GMT

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.

loading already existing tables with add load

Wed, 16 Jun 2010 14:22:03 GMT

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