Can we start multiple session in qlikview script?

[alex_stone]

1. We connect to database, and then get a date list form some tables.

2. For index=0 to NoofRow("DateList")

all logic includes in this loop, some like below

Result:

load

     ID,

     Name,

     Location

;

SQL select *  into #temp from Business_Partner

select ID, Name, Location from  #temp

next index

Question: Will prompt that the template table(#temp) already exist when start the second loop. Is there any solution that disconnect the current connection and then re-connect it to release the template table.

[alex_stone · Accepted solution]

For index=0 to NoofRow("DateList")

all logic includes in this loop, some like below

Result:

load

     ID,

     Name,

     Location

;

SQL select *  into #temp from Business_Partner

select ID, Name, Location from  #temp

Drop_Temp_Tables:

Load

*

;

SQL DROP TABLE #tem

SELECT * from anyTable;

next index