topic Re: Database Comparison in QlikView

Database Comparison

Tue, 15 Jul 2014 06:47:49 GMT

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.

Re: Database Comparison

amit_saini — Tue, 15 Jul 2014 07:36:53 GMT

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

Re: Database Comparison

amit_saini — Tue, 15 Jul 2014 07:49:12 GMT

Sorry, Please follow this attachment.

Thanks,
AS

Re: Database Comparison

jonathandienst — Tue, 15 Jul 2014 08:02:08 GMT

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

Re: Database Comparison

Tue, 15 Jul 2014 08:27:56 GMT

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