Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
MVP
MVP

Re: 2 Databases compare

It seems that you might be getting the error for table DB02, because this table is getting concatenated to DB01 (because all fields are common for them). You have to avoid this auto concatenation by using NOCONCATENATE keyword like:

ODBC CONNECT TO [DB01;DBQ=DB01] (XUserId is asdasdasd, XPassword is aPassword);

"DB01":

Load *,

Date(Floor(DATETIME)) as Date Where

Date(DATETIME,'DD.MM.YYYY')>='23.07.2013';

SQL SELECT ID,

                   DATETIME   

FROM Test1.table1;

ODBC CONNECT TO [DB02;DBQ=DB02] (XUserId is asdasdasdasdasssda, XPassword is anotherPassword);

"DB02":

NoConcatenate

Load *,

Date(Floor(DATETIME)) as Date Where

Date(DATETIME,'DD.MM.YYYY')>='23.07.2013';

SQL SELECT ID,

                     DATETIME

FROM Test2."table2";

Not applicable

Re: 2 Databases compare

if I load it then there is:

Connecting to DB01;DBQ=DB01

Connected

DB01 << table1 x lines fetched

Connection to DB02;DBQ=DB02

Conncetec

DB01<< table2

....

Is that normal that DB01 is two times there.

Could also the tablenames be a problem, because they have the same name,  just from another DB

Not applicable

Re: 2 Databases compare

I'm getting the error: DB02 not found

MVP
MVP

Re: 2 Databases compare

Have you put NoConcatenate properly?

Not applicable

Re: 2 Databases compare

Wait I'm not sure. I look shortly

Not applicable

Re: 2 Databases compare

My fault. I put it in front of InnerJoinTable....
It's loading now and looks better. I'll write when it's finished with loading

Highlighted

Re: 2 Databases compare

You should use aliases for fields of each table as I showed in the last attached example because without aliases, you add rows to the same table.