loop in include file

[#1]

Hi Experts,

         i am having three tables, tableA,tableB,tableC..from four different regions say east,west,north,south. each region is having its own database. now  i have to extract data from four regions so we have four connection strings .i wanted to include these four connection strings

in one script file and extract data. how can i achevie this

Note: getting same tables from all the four regions

Thanks in advance

[rohit214]

Hi,

At a time you can use one connction string.

so what you can do for example

for getting the north data make a connection string and fetch the required tables and disconnect it in last of the script.

and do rest of the other region so in a single script you can use n no. on connetion script.

ex:

ODBC connection;

Load

f1,

f2,

.

.

.fron north;

disconnect;

ODBC connection

Load

f1,

f2,

from south;

disconnect;

and so on

Regards

Rohit

[#3]

hi rohit,

   in my case i am calling connection strings from external file through include statement

[#4]

Hi,

You Can connect to different connection string in a single file

eg: 1.Connect to connectionstring1

     2. Load tables from connectionstring1

     3. Connect to ConnectionString2

     4. Load Tables from ConnectionString2.

       .

......n

Regards,

Joshmi

[rohit214]

http://community.qlik.com/message/546230#546230

check that link

Regards

Rohit

[#6]

hi gorge,

   here iam saying about text file not qv file

[senpradip007]

Try to use for each...Next loop, you may resolve the issue:

1. First load all connections string

2. use for each loop if your table structure is same in all dbs.

[miikkaqlick]

Hi!

You should write your include file like this:

Let vCon1 = Connection string 1

Let vCon2 = Connection string 2

Then in script

$(vCon1)

Load A

From Con1

$(vCon2)

Load A

From Con2

Br,

Miikka

[marcus_sommer]

Have a look here:

Re: Connecting to multiple OLE DB servers with a loop.

Re: Change the connection script using a macro - newbie question

- Marcus