topic Re: Problems with different databases in QlikView

Problems with different databases

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi!

I have two different data bases: one database (old database) contains data until december of my processes.

The other database (new database) contains data from december to now.

To achieve my kpis this year, y need fields from new database, but if i need to compare with the same kpis in the last year, i need to find the fields in the old database....

For example:

OLDBBDD:

Table A Table B Table C

Field 1 Field 1 Date

Field 2 Field 2 Field1

NEWBBDD:

Table A Table B Table C

Field 11 Field 12 Date2

Field 21 Field 23 Field12

Both BBDD have different fields, so to calculate one kpi this year i have to use TableA.Field1 and TableC.Date1 and to calculate THE SAME KPI the last year i have to use TableA.Field11 and TableC.Date2.

Do you know the process I must follow to get done comparing the KPI?

Thanks a lot.

Re: Problems with different databases

Gysbert_Wassenaar — Wed, 20 Jul 2016 15:38:22 GMT

Rename the fields from the new database during the script execution so they have the same name as they had in the old database.

CONNECT ...old_db...;

TableA:

SELECT Field1, Field2, 'OldDB' as Source FROM .... ;

DISCONNECT;

CONNECT ...new_db...;

SELECT Field11 as Field1, Field21 as Field2, 'NewDB' as Source FROM .... ;

Re: Problems with different databases

maxgro — Wed, 20 Jul 2016 15:41:46 GMT

when you load the data in Qlik from the 2 db rename the fields and concatenate;

example for table A

Table:

load

[Field 1] as Field1,

..........,

'OLDDB' as Db

;

SQL

Select * from tableAinolddb;

concatenate (Table)

load

[Field 11] as Field1,

..........,

'NEWDB' as Db

;

SQL

Select * from tableAinolddb;

then use set analysis to compare this year to previous year

Re: Problems with different databases

effinty2112 — Wed, 20 Jul 2016 15:42:15 GMT

Hi Paula,

The databases' field names may have changed but if their meanings are the same then why not concatenate?:

Along these lines:

Table A:

Load

Field 1,

Field 2

From OLDBBDD;

Concatenate(Table A)

Load

Field 11 as Field 1,

Field 12 as Field 2

From OLDBBDD;

Good luck

Andrew

Re: Problems with different databases

chrisg — Wed, 20 Jul 2016 15:42:17 GMT

Hi Paula,

try to load the data of the first DB

with:

Load

Field1;

Filed2

From Table A;

and the second with

Concatenate Load

Field 11 AS Field1;

Field 1" AS Field"

From

the result is one table with all the data from Tabel A (old and new)

Hope that helps

Christoph