Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

gautik92
Valued Contributor III

Using 2 Database

I am facing an issue in qliksense while connecting two database

both the database having same Tablenames

when i am loading with two database connection it is showing error

how can i resolve this?

1 Solution

Accepted Solutions

Re: Using 2 Database

Give the tables different names if the data should stay in different tables. If the data should end up in one table and the source tables do not have exactly the same number of fields with the exact same case sensitive names the you need to force concatenation of the date use the CONCATENATE keyword.

LIB CONNECT TO 'MyDataConnection1';

MyResultTable:

SQL Select * FROM Table1;

DISCONNECT;

LIB CONNECT TO 'MyDataConnection2';

CONCATENATE (MyResultTable)

SQL Select * FROM Table1;


talk is cheap, supply exceeds demand
3 Replies
miguelbraga
Valued Contributor III

Re: Using 2 Database

Hey there,

Can't you rename your table names in the two databases? I don't think you can upload two tables from two different databases with the same name. If you can't change the database tables name, try creating two different connections in your qlik sense.

Hope this guidelines can help you

Regards,

MB

Re: Using 2 Database

Give the tables different names if the data should stay in different tables. If the data should end up in one table and the source tables do not have exactly the same number of fields with the exact same case sensitive names the you need to force concatenation of the date use the CONCATENATE keyword.

LIB CONNECT TO 'MyDataConnection1';

MyResultTable:

SQL Select * FROM Table1;

DISCONNECT;

LIB CONNECT TO 'MyDataConnection2';

CONCATENATE (MyResultTable)

SQL Select * FROM Table1;


talk is cheap, supply exceeds demand
nizamsha
Valued Contributor

Re: Using 2 Database

Disconnect the first connection string after loading the table and store it

create a  new connection string for the second data base it should work