5 Replies Latest reply: Aug 23, 2016 5:45 AM by Charlie Hudson RSS

    Incrementally load data from a database

    Marc van der Peet

      Dear all,

       

      I'm am loading data from a database into Qlikview using a SQL statement. Normal loading works fine but I would like to implement a load which only loads new records (the column: "ALTERNATIVE_DISPLAY_COLUMN1"; is a column that has a unique ID.

       

      I have tried to accomplish it using the following code:

       

      Test:
      LOAD
      "ALTERNATIVE_DISPLAY_COLUMN1";

      SQL SELECT "ALTERNATIVE_DISPLAY_COLUMN1"
      FROM "APEX_040100"."APEX_APPL_LOAD_TABLE_LOOKUPS";

      Concatenate
      LOAD
      "ALTERNATIVE_DISPLAY_COLUMN1";

      SQL SELECT "ALTERNATIVE_DISPLAY_COLUMN1"
      FROM Sales.qvd(qvd) where not Exists(ALTERNATIVE_DISPLAY_COLUMN1);

      Store text into Sales.qvd(qvd);

      Drop table Test;

       

      This however does not work. Could anybody advise me on where I go wrong?