topic Join giving more rows than expected in QlikView

Join giving more rows than expected

QFanatic — Thu, 11 Feb 2021 07:54:17 GMT

hi all

Please find attached 2 QVd's.

These 2 join on the #Key field.

EV qvd contains 1152 Rows. EV_Relationship contains 1416. When I join them on the key, the result contains 1860 rows...So surely they're not joining as expected.

How can I find out what/where the problem is? In my mind, there should be some chart that will show up the problem?

Much appreciated.

(How do I attach QVD's to the post - get error saying

The attachment's ev_relationship.qvd content type (application/octet-stream) does not match its file extension and has been removed.) PLEASE assist

Re: Join giving more rows than expected

rubenmarin — Fri, 12 Feb 2021 08:00:58 GMT

Hi @QFanatic, in document properties-> Tables, on the lower box, when there is a list of the fields, look for the #key field and check if 'Number of values' is the same as 'Number of sitinct values', if there is not the same number that means that #Key is not a unique identifier and this can cause duplicates.

You can do a temporary document that loads all values from a qvd, and create a simple table with #Key as dimension and Count(#Key) as expression, sort descendent and the ones with values over '1' will be the ones causing duplicates.

Re: Join giving more rows than expected

QFanatic — Sat, 13 Feb 2021 17:56:22 GMT

Thank you so much - this was very valuable