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

[Anonymous]

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

[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 ;