Qlikview for data validation

[#1]

Hi,

I am looking for a solution for the following scenario.

Source Table:

T1-- Column1, Column 2, Column 3

ETL Process to load the source table into Target Table

We load the same data in Target Table T2 : Column1, Column 2 , Column 3

Now I would like design an app and give the control to users to validate the data by selecting the desired source columns and respective target table columns to compare the data and should only give the unmatched rows.

What the are the better ways to use Qlikview for QC testing (databases: source to target).

Thanks,

Venu

[felipedl]

Hi Venu,

Attached an example on what can be done.

Felipe.

[#3]

Hi Felipe,

Thanks for the reply. I don't see the attachment in your reply.

Venu