https://community.qlik.com/t5/Talend-Studio/Excel-Matrix-to-related-Database-Tables/m-p/2234224#M23658 Bump to the Top.<BR />I would love some help with this as well. Mon, 24 Oct 2011 14:06:02 GMT _AnonymousUser 2011-10-24T14:06:02Z https://community.qlik.com/t5/Talend-Studio/Excel-Matrix-to-related-Database-Tables/m-p/2234223#M23657 Hi Folks, <BR />i have a source Excelfile and three target tables: <BR />1. Exemplary Excel File <BR /> Car House Boat <BR />------------------------------------------- <BR />Mike 1 0 1 <BR />James 0 1 1 <BR />Scott 0 0 1 <BR />This excel file shows the relations: Mike has a car and a boat, James has a house and a boat, scott only has a boat. <BR />I have three tables: <BR />Person <BR />Owning <BR />PersonToOwning (Relationtable to build up the matrix) <BR /> <BR />Model: <BR />Person PersonToOwning Owning <BR /> <BR />Person and Owning Tables are filled already from Excel File, the internal Id Columns of those tables are also filled. But how can i put the matrix into the relation-Table PersonToOwning by using the generated Ids from Person and Owning Table? <BR />I´ll need this transformation for further purposes, so it would be great if this can be created as an abstract transformation, not including special variables for "house", "boat" etc. also the number of ownings and the number of names is NOT fixed... <BR /> <BR />Let me thank you for your support in advance! <BR />Regards, <BR />Philipp Sat, 16 Nov 2024 13:23:02 GMT https://community.qlik.com/t5/Talend-Studio/Excel-Matrix-to-related-Database-Tables/m-p/2234223#M23657 Anonymous 2024-11-16T13:23:02Z https://community.qlik.com/t5/Talend-Studio/Excel-Matrix-to-related-Database-Tables/m-p/2234224#M23658 Bump to the Top.<BR />I would love some help with this as well. Mon, 24 Oct 2011 14:06:02 GMT https://community.qlik.com/t5/Talend-Studio/Excel-Matrix-to-related-Database-Tables/m-p/2234224#M23658 _AnonymousUser 2011-10-24T14:06:02Z