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
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.
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.
