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