This content has been marked as final.
Show 2 replies
-
LEFT JOIN
Stefan Wühl Oct 27, 2011 12:08 PM (in response to mrkachhia)mrkachhia,
I don't believe there's a way to do that using a join (at least if you use only the shown fields).
The important thing would be to know how you handle this in your business, i.e. how do you decide in your real business which record of your purchase table belongs to which customer. Then it might be possible to tell QV what to do (Maybe by adding a new field to both tables indicating an order of records, if fields used to join have the same values for multiple records, but are not really duplicates for all fields).
Regards,
Stefan
-
LEFT JOIN
Kamal Naithani Oct 28, 2011 12:21 AM (in response to Stefan Wühl )Hi,
I think that you must have a unique field that may differentiate between the two tables.You must ask with the business user ,because qlikview will not be able to differentiate
-