topic Re: Change Script ? in QlikView

Change Script ?

Thu, 24 Sep 2015 07:40:08 GMT

Hey guys,

I have 2 Databases from two companys, which i want to use in one application. The Databases are the same concerning to Tablenames etc..

So I would only have to change the FROM Statement in my loadparts like

LOAD

SQL SELECT

FROM companyA...

LOAD

SQL SELECT

FROM companyB...

So what i want to achieve is 2 scripts, one for company A and one for company B which can be easily changed in one application.

Any Ideas?

Re: Change Script ?

petter — Thu, 24 Sep 2015 07:47:02 GMT

You should probably ADD a new CONNECT statement after the first LOAD and before the second LOAD.

Re: Change Script ?

alexandros17 — Thu, 24 Sep 2015 07:50:58 GMT

Connect to ... DB1

Select... From .Table1

Connect to ... DB2

Select... From .Table2

Re: Change Script ?

Thu, 24 Sep 2015 08:04:11 GMT

But how can I switch between these two different scripts?

I dont want to have all the data from both companies in the application at once.

Re: Change Script ?

Anonymous — Thu, 24 Sep 2015 08:07:32 GMT

hi leon,

You can achieve your requirement in same Script .Make a connection to a first DB and then code or script under that connection and Store files from that database in your system than disconnect the database. Next, Make a connection to a second DB and then code or script under that connection and Store files from that database in your system than disconnect the database and so on.

1st Database:

Connection String #1

ODBC Connect to .........

TableA

Load

.....

....

From

Store TableA into …/..../.qvd(qvd);

Disconnect;

2nd Database:

Connection String #2

ODBC Connect to .........

TableB

Load

.....

....

From

Store TableB into …/..../.qvd(qvd);

Disconnect;

Etc...

At a time, there will be only one Connection Active.

You can use Number of Connect Commands to fetch Data.

Re: Change Script ?

petter — Thu, 24 Sep 2015 08:14:46 GMT

LET CompanyAConn = 'CONNECT def.....';

LET CompanyAFrom = '......';

LET CompanyBConn = 'CONNECT xyz.....';

LET CompanyBFrom = '......';

LET Company = 'A'; // Change here to switch the company

LET CompanyConnectString = Company$(Company)Conn;

LET FromClause = Company$(Company)From;

$(CompanyConnectString);

LOAD

SQL

SELECT

.....

FROM $(FromClause);

Re: Change Script ?

puttemans — Thu, 24 Sep 2015 08:25:01 GMT

You could make the 'from' statement using a variable (vCompany), which you define with an 'input box' (vCompany=A or B) for instance. That way you can easily switch between both companies in the same application.