topic Re: Calculations post joining data from 2 databases in QlikView

Calculations post joining data from 2 databases

nagarajan_iyer — Fri, 16 Nov 2018 15:07:57 GMT

I have a situation here. I pulled data from 2 different database and joined them using "Left keep" formula.

Post this i wanted to do few calculations wherein i need data points from both the database. I tried creating a new table and loading the datapoints from both database but wasnt able to do so. Any help would be appreciated.

Re: Calculations post joining data from 2 databases

jensmunnichs — Fri, 16 Nov 2018 15:40:58 GMT

Could you post the script you have so far? And what kind of calculations are you trying to do?

Re: Calculations post joining data from 2 databases

nagarajan_iyer — Tue, 20 Nov 2018 07:58:18 GMT

Connect ... // Connect to the first database/server

Table1:

Load ...

Select ...

From (table in first database);

Connect ... // Connect to the second database/server

Left Join (Table1)

Load ...

Select ...

From (table in second database);

this is my original script

Now i wanted to do calculations which involved data from both database and hence i have joined then (using the keep function)

eg: Amount from database 1- amount from second database

Eg: date from database 1- date from database 2 as remaining days

i am unable to do this and need some guidance.

Re: Calculations post joining data from 2 databases

sergioskv — Tue, 20 Nov 2018 08:04:37 GMT

Try to use resident load from DB1-join-DB2 with noconcatenate.

When do ur transformation and drop temp tables (DB1-join-DB2).

Sergio S.