Copying contents of a temp table

[#1]

Hi everyone,

This might have a quick and simple answer but I am trying to copy the contents of one temp table to another one. Anyt idea how this can be done?

Eg:

connect to OLE DB ....

sql select *

from "table_name";

load abc,

          pqr,

          xyz

resident #temp;

drop table #temp;

now, how can I copy contents of this #temp table into another temp table say #test ??

Please let me know!

Thanks!

[MayilVahanan]

HI,

     Before drop table, you can use like this,

     #test:

     Load * resident #temp;

     Drop table #temp;

Hope it helps

[#3 · Accepted solution]

He,

If I understood you correctly, you could do this:

#test:

noconcatenate load *

resident

#temp;

drop tables #temp;

You have to make sure that you drop the original table otherwise qlikview will automaticaly make a syntetic key between the tables.

gr

frank

[#4]

Hi Mayil,

Sorry for the wrong reply previously!
This script runs but doesnt give me another table #test!
Any suggestions?

[#5]

frankcrezee,

This works just perfect!

Thanks!

Appreciate prompt response!