Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
alex_stone
Creator
Creator

Can we start multiple session in qlikview script?

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.

1 Solution

Accepted Solutions
alex_stone
Creator
Creator
Author

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

View solution in original post

1 Reply
alex_stone
Creator
Creator
Author

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