Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am new to Qlikview using Qlikview 10 personal edition.
Can anyone please let me know how to compare two different DB in qlikview.
Having 2 databases with 3 tables each with same sets of columns..
Connect to MyDB1
// Or load from File1
Load DB1 as Source, x1, x2, x3;
SELECT * FROM myTable1;
Connect to myDB2
// Or load from File2
Load DB2 as Source, x1, x2, x3;
SELECT * FROM myTable2;
You can then add "Source" as a dimension to your table, filter on it, or do anything else you want to create comparisons.
Good luck.
do you want to show side by side that 2 tables? for what reason may i ask...
Actually yes...
Let me explain you the exact scenario..
I am dealing with two data source x & y.
x DB has three columns x1,x2,x3 and y DB has same three columns x1, x2, x3.
Need to compare x.x1----y.x1, x.x2---y.x2, x.x3---y.x3....
Is it possible to do in qlikview.
may i know this 2 source is the same or it only have the same field name?
Connect to MyDB1
// Or load from File1
Load DB1 as Source, x1, x2, x3;
SELECT * FROM myTable1;
Connect to myDB2
// Or load from File2
Load DB2 as Source, x1, x2, x3;
SELECT * FROM myTable2;
You can then add "Source" as a dimension to your table, filter on it, or do anything else you want to create comparisons.
Good luck.
Thanks .. I have done it successfully....
Thanks .. I have done it successfully....