Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Copying contents of a temp table

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!

1 Solution

Accepted Solutions
Not applicable

Re: Copying contents of a temp table

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 Replies

Re: Copying contents of a temp table

HI,

     Before drop table, you can use like this,

     #test:

     Load * resident #temp;

     Drop table #temp;

Hope it helps

Not applicable

Re: Copying contents of a temp table

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

Not applicable

Re: Copying contents of a temp table

Hi Mayil,

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

Not applicable

Re: Copying contents of a temp table

frankcrezee,

This works just perfect!

Thanks!

Appreciate prompt response!

Community Browser