topic Re: Temporary table into existing table in QlikView

Temporary table into existing table

Wed, 25 Nov 2020 16:16:04 GMT

In my script I first load a table using:

[Table_A]:

Load

field1,

field2,

...

fieldN

from [Path_to_my_excel];

Later I have create a temporary table, let's say, TEMP_TABLE, from [Table_A] and then join TEMP_TABLE with another table.

The result joining table, TEMP_TABLE, has the same columns as [Table_A] but now what I want is to copy entire temporary table TEMP_TABLE into [Table_A], but not append to it, I mean, I want to remove all the records from [Table_A] and copy to [Table_A] the new records from temporary table TEMP_TABLE.

So how to copy all the records from TEMP_TABLE into [Table_A] (not keeping existing [Table_A] records)?

Re: Temporary table into existing table

afurtado — Sun, 24 Jul 2016 22:33:57 GMT

Tony,

drop table Table_A;

RENAME TEMP_TABLE to Table_A;

Re: Temporary table into existing table

sunny_talwar — Sun, 24 Jul 2016 22:36:53 GMT

How about Dropping Table_A and renaming TEMP_TABLE to Table_A whenever you have the TEMP_TABLE ready to be called Table_A