Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gautik92
Specialist III
Specialist 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
Gysbert_Wassenaar

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

View solution in original post

3 Replies
miguelbraga
Partner - Specialist III
Partner - Specialist III

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

Gysbert_Wassenaar

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
Specialist II
Specialist II

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