Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Validating 2 data sources using QVDs

Hi,

I have been given 2 QVD's to compare, both QVDs have the same field names, the reason for the check is one is from an Access data base and the other is has been ported from Access to SQL.

That is why I need the check.

I am thinking to join fields in a hash function by groups of fields,ie Hash(FieldA&FieldB&FieldC)

Then compare in Excel, before I start does anyone have a better solution.

Thanks

Neil.

2 Replies
Highlighted
Creator III
Creator III

Hi Neil,

Using Hash function is a good Idea.

You can pull the data from different sources, Join them, create two hash map fields (one from Access and one from SQL), compare and flag there only if they are not matching. Using the flag, you can able to identify if there is a data change.

You don't need to pull out data in excel to validate.

Hope this helps you.

Regards,

Akshaya

Highlighted
Creator II
Creator II

Hi Neil,

I am sure there might be different and more effective ways - if you want to export into excel

DataValidation:

LOAD

Field1,

Field2,

Field3,

Field4

'From Access' AS DataSource

order by someField_that_helps to easily sort in excel

From First_QVD;

CONCATENATE(DataValidation)

LOAD

Field1,

Field2,

Field3,

Field4

'From Access To SQL' AS DataSource

From Second_QVD

order by someField_that_helps to easily sort in excel;