topic how to compare two qvds in QlikView

how to compare two qvds

Anonymous — Wed, 17 Jun 2015 14:38:15 GMT

how to compare the records of two similar qvds(Table with 130 filelds of Same Name in each qvd ), when there is no Primary key

Is it possible to compare these stuff.

John

Re: how to compare two qvds

ramoncova06 — Wed, 17 Jun 2015 14:46:05 GMT

what do you mean by compare ?

are you referring to the content itself or the number of rows, fields, etc ... ?

if you want to identify if they are any missing rows from each other then you need to identify a key field and you could apply where exists or joins

Re: how to compare two qvds

Oleg_Troyansky — Wed, 17 Jun 2015 14:51:03 GMT

I'd suggest loading both tables using QUALIFY (to avoid linking on all fields) while adding a new field with the row number.

Then, you can compare row by row.

Alternatively, you can UNQUALIFY the combination of fields that you want to compare by (for example, Product, Customer, and Date), and compare other fields based on the matching combinations of your key fields.

You'd need to quality and unqualify different sets of fields, depending on the needs of your comparison.

best,

Oleg Troyansky

QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense

Re: how to compare two qvds

stigchel — Wed, 17 Jun 2015 14:55:41 GMT

You can create a primary key by using Autonumberhash where you include the fields that make your records unique e.g.

autonumberhash128(EventDate, Description);

From the help

autonumberhash128(expression {, expression})

Calculates a 128-bit hash of the combined input expression values and the returns a unique integer value for each distinct hash value encountered during the script execution. This function can be used e.g. for creating a compact memory representation of a complex key.

Example:

autonumberhash128 ( Region, Year, Month )

Re: how to compare two qvds

petter — Wed, 17 Jun 2015 15:01:51 GMT

Actually if you do a load script a join on the common fields (which is automatic in QlikView) should reveal the differences and similarities between the tables.