Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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;
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
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;
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