topic Re: Can we start multiple session in qlikview script? in QlikView

Can we start multiple session in qlikview script?

alex_stone — Fri, 20 Dec 2013 02:35:27 GMT

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.

Re: Can we start multiple session in qlikview script?

alex_stone — Tue, 24 Dec 2013 01:40:39 GMT

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