topic Load data through external script in QlikView

Load data through external script

alwinsch — Wed, 29 Aug 2012 12:08:20 GMT

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

sreenivas — Wed, 29 Aug 2012 12:10:34 GMT

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

alwinsch — Wed, 29 Aug 2012 12:15:54 GMT

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 — Wed, 29 Aug 2012 12:17:45 GMT

yes