Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

alwinsch
Contributor

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

Tags (2)
1 Solution

Accepted Solutions
sreenivas
Contributor III

Re: Load data through external script

yes

3 Replies
sreenivas
Contributor III

Re: Load data through external script

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

alwinsch
Contributor

Re: Load data through external script

So i use in my final QVW file:

 

 

OLEDB CONNECT32....

 

include (external.txt)

Oledb connect 32....

include (external.txt)

is this what you mean?

sreenivas
Contributor III

Re: Load data through external script

yes

Community Browser