Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
alwinsch
Creator
Creator

Load data through external script

Hi all,

I created a Txt file, which contains a select statement from SQL.

I want to use this text file as my datasource for qvw file.

But

- I want to load the same script 3 times... because we have 3 identical DB's

How can i do this?

Do i create in my QVW file

first the OLE DB provider and after this sentence

i reference to the extern script.

then i create a new OLE DB (to the next Database)

and again load the sript?

Or is there another way?

Kind Regards,

Alwin

1 Solution

Accepted Solutions
3 Replies
sreenivas
Creator III
Creator III

Create 3 tabs and each tab to particular db connection string and load the data.

alwinsch
Creator
Creator
Author

So i use in my final QVW file:

 

 

OLEDB CONNECT32....

 

include (external.txt)

Oledb connect 32....

include (external.txt)

is this what you mean?