Compare 2 QVDs

[Anonymous]

Hi Experts,

I want to compare data from 2 qvds and present it in a qvw. Can someone suggest the ideal approach to do this?

Thanks in advance.

[alexandros17]

What do you mean with compare?

You can load each qvd, but what do you want to do then?

Let me know

[Anonymous]

The 2 qvds are from different environment. (PROD and UAT)

So, I want to do a comparison of data in the front end after loading them.

As of now, I am simply loading data from 2 files, using qualify (as the field names are similar) and then pulling the data in the front end in 2 different straight tables.

Just wanted to know , is there any other ideal approach to do this?

Hope I made myself clear.

[maleksafa]

if you are dealing with numbers, the ideal thing i guess is to load both qvds in different tables or same table but with different flag (to identify them) and then create a statistics box on each set of data and do the comparison.

[giakoum]

embarrassing as it may sound , I use Excel to compare 2 data sets

Just creating a column subtracting the same field from each data set and dragging it across the dimension. if there is a value other than 0, there might be a potential issue.

[Peter_Cammaert]

My initial idea (some years ago when dealing with a problem with Incremental loads of very large tables) was:

Make a QVW document that:

• Loads the first version of the QVD and adds a primary key to it
• Loads the second version of the QVD and joins it to the first (OUTER JOIN)
• Reloads the resulting table and creates flags for all field pairs that differ.
• Create a few UI objects with counters for nr of records and a table with counters for field differences.

If you want to do it for all fields, you're in for a lot of work. If you want to do this for a few important fields, or just to count the number of differing records, it is doable.

[alexandros17]

Clear, but analysis depend on totals, on selections and so on, the best thing would be reading the 2 qvd leaving the key fields with the same name (Unqualify those fields) in order to put them as dimension and add expressions from other fields that sum values

It's an idea, let me know

[Anonymous]

Thank you guys for all the help! 🙂