How to keep a table and load a new one?

[#1]

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?

[martin59]

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

[#3]

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;