topic How to keep a table and load a new one? in QlikView

How to keep a table and load a new one?

Mon, 11 Jul 2011 15:26:17 GMT

I have one table already loaded with several million rows. I have a new table that I want to add, but I don't want to reload the first one. I have seen a bunch of stuff about ADD and REPLACE in the partial reload, but looks like that it to append data to the existing table but not load a separate table. Is this possible to keep an old table and load a brand new one?

How to keep a table and load a new one?

martin59 — Mon, 11 Jul 2011 15:37:07 GMT

Hi Christine,

You have to do an ADD LOAD. For this :

- save your application in another file to keep an old version if that fails.

- write your load script (for the new table)

- write the key word ADD just before your load script.

- verify you haven't JOIN (...) LOAD or KEEP (...) LOAD which didn't respect the partial reload. If you have this syntax, comment it.

- return to the user interface (where you can create your charts)

- File / Partial Reload (or ctrl+shift+R)

Logically, datas already in the document will stay, and new file will be loaded.

Hope that helps you and sorry for my poor english !

Martin

How to keep a table and load a new one?

Mon, 11 Jul 2011 15:46:04 GMT

I just figured it out, too... With this script I keep my existing AIR table and add my new HOTEL table:

RENAME TABLE AIR TO AIR2;

AIR:
ADD NOCONCATENATE LOAD * RESIDENT AIR2;

DROP TABLE AIR2;

HOTEL:
REPLACE LOAD *;
SQL
Select * from table;