Database Comparison

[#1]

I just started working with qlikview and new to it. And help to create an application

I am trying to create a utility to compare data from 2 databases. We usually dump Request data from Prod  to our Dev environment.

I need to compare data from two Databases having same Table and Column Names.

For every Table, I need to compare column Values. There is 1 key filed say Request Id  against which I will compare data whether it matches or not.

Please suggest, how to proceed on this.

[amit_saini]

Vineeta,

Please see the attachment, In this I'm loading data from two source having common connection. I'm comparing data by using if statement kindly see the script in attached application.

Thanks,
AS

[amit_saini]

Sorry, Please follow this attachment.

Thanks,
AS

[jonathandienst]

Hi

I would load the data into a single table likes this:

Compare:

LOAD *,

  'DB1' As Source;

SQL SELECT * From DB1.Table;

Concatenate

LOAD *,

  'DB2' As Source;

SQL SELECT * From DB2.Table;

Now you can use expressions like these to compare the data and to perform difference calculations:

Sum({<Source={'DB1'}>} Value)

Sum({<Source={'DB2'}>} Value)

Count({<Source={'DB1'}>} Value) - Count({<Source={'DB2'}>} Value)

HTH

Jonathan

[#5]

I am also following the same way. But there are around 50 tables and more than 300 columns , which is consuming lots of time due to manual work . Do I need to write alias for each of the table. or any other alternative