Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

Not applicable

many to many relationship

hello.

i have those 2 tables with many to many relationship

the problem is that one donation can have many equipment and the same equipment can be in many donations(there are many of it)

i need to fins all equipment that one donation has

equipment_id

equipment_name
123A
234B
345C
456D
567E
678F

equipment_iddonation_id
123AABBCCDD
234AABBCCDD
345AABBCCDD
456AABBCCDD

i need to have one table with all this information

3 Replies

Re: many to many relationship

If you want one result table then join the tables. But I don't think you should really. Two tables are fine if they are associated correctly.

ResultTable:

LOAD equipment_id, equipment_name FROM equipment;

JOIN(ResultTable)

LOAD equipment_id, donation_id FROM donations;


talk is cheap, supply exceeds demand
Not applicable

Re: many to many relationship

i do join the tables.

the problem is that i need to connect this table to the main table with the "donation_id" and here it doesn't work because of the many to many relationship.

one donation can have many equipment and the same equipment can be in many donations(there are many of it)

Re: many to many relationship

Can you explain what "and here it doesn't work" means. What is"it" and what's your definition of "works" in this case.


talk is cheap, supply exceeds demand
Community Browser