Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
tinkerz1
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
adityaakshaya
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

qvraj123
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;