Discussion Board for collaboration regarding Qlik DataMarket.
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
i need to have one table with all this information
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.
LOAD equipment_id, equipment_name FROM equipment;
LOAD equipment_id, donation_id FROM donations;
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)
Can you explain what "and here it doesn't work" means. What is"it" and what's your definition of "works" in this case.