How to over come Many to Many Relation ship?

[#1]

Hi

Can any one please guide me on how to avoid many to many relation ship between the tables.

Scenario: I have two tables  table 1 and table 2   in table 1 contact no is having many contracts as well as Table 2 contract no also having many contact nos ,if i use these tables in qlikview i am getting  redundant data. how to handle this scenario.

[#2]

hi john,

use qualify *

and unqualify the key field!

Regards,

Barathiraja

[amit_saini]

John,

This kind of links will create lots of synthetic key , better to avoid them . check below:

Link

Thanks,

AS

[jonathandienst]

Hi

The contact table should contain one row per contact with a unique ID (eg ContactID), likewise with the contract table (ContractID). Then use a link table with the fields ContactID and ContractID for the many to many links.

HTH

Jonathan

[sujeetsingh]

John,

Dienst has given you the right option well you can use Applymap and joins too to implement the logic.

[#6]

Hi Jonathan dienst

If possible can you please explain me with an example.

Thanks

John