topic Re: loop in include file in QlikView

loop in include file

Fri, 26 Sep 2014 09:05:03 GMT

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

Re: loop in include file

rohit214 — Fri, 26 Sep 2014 09:12:11 GMT

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

Re: loop in include file

Fri, 26 Sep 2014 09:20:20 GMT

hi rohit,

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

Re: loop in include file

Fri, 26 Sep 2014 09:23:38 GMT

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

Re: loop in include file

rohit214 — Fri, 26 Sep 2014 09:28:57 GMT

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

check that link

Regards

Rohit

Re: loop in include file

Fri, 26 Sep 2014 09:29:24 GMT

hi gorge,

here iam saying about text file not qv file

Re: loop in include file

senpradip007 — Fri, 26 Sep 2014 09:30:57 GMT

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.

Re: loop in include file

miikkaqlick — Fri, 26 Sep 2014 09:35:04 GMT

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

Re: loop in include file

marcus_sommer — Fri, 26 Sep 2014 10:02:21 GMT

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