Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
HI,
Before drop table, you can use like this,
#test:
Load * resident #temp;
Drop table #temp;
Hope it helps
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
Hi Mayil,
Sorry for the wrong reply previously!
This script runs but doesnt give me another table #test!
Any suggestions?
frankcrezee,
This works just perfect!
Thanks!
Appreciate prompt response!