Discussion Board for collaboration on QlikView Scripting.
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?
connect to OLE DB ....
sql select *
drop table #temp;
now, how can I copy contents of this #temp table into another temp table say #test ??
Please let me know!
Go to Solution.
If I understood you correctly, you could do this:
noconcatenate load *
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.
Before drop table, you can use like this,
Load * resident #temp;
Drop table #temp;
Hope it helps
Sorry for the wrong reply previously! This script runs but doesnt give me another table #test! Any suggestions?
This works just perfect!
Appreciate prompt response!