Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Temporary table into existing table

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)?

1 Solution

Accepted Solutions
afurtado
MVP
MVP

Tony,

drop table Table_A;


RENAME TEMP_TABLE to Table_A;

furtado@farolbi.com.br

View solution in original post

2 Replies
afurtado
MVP
MVP

Tony,

drop table Table_A;


RENAME TEMP_TABLE to Table_A;

furtado@farolbi.com.br
sunny_talwar

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

[Table_A]:

Load

  field1,

  field2,

  ...

  fieldN

from [Path_to_my_excel];

.

.

.

DROP Table Table_A;

RENAME Table TEMP_TABLE to Table_A;