Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
nadig_sahana
Contributor III
Contributor III

can we read / extract data directly from multiple database instances and join the tables in qlikview

hi,

can we read / extract data directly from multiple database instances and join the tables in qlikview?

Example, Table A from Database A, Table B from Database B, I would like to join Table A and B in QlikView.

regards,

Sahana

10 Replies
colin_albert

Yes, you can do this, but only 1 connection is active at any time, so if you are changing connections you will need to have your connect statements in the correct position in the script.

You can use concatenate, mappings and joins in the QlikView script to combine that data as required.

e.g.

Connect statement 1 ;

load data from connection 1 ;

Connect statement 2 ;

load data from connection 2 ;