Comparing Data

[#1]

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..

[rotero]

do you want to show side by side that 2 tables? for what reason may i ask...

[#3]

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.

[rotero]

may i know this 2 source is the same or it only have the same field name?

[Or · Accepted solution]

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.

[#6]

Thanks .. I have done it successfully....

[#7]

Thanks .. I have done it successfully....