topic Joining Tables in QlikView https://community.qlik.com/t5/QlikView/Joining-Tables/m-p/409039#M565967 <HTML><HEAD></HEAD><BODY><P>Hi folks,</P><P></P><P>I have the data structure shown in the picture. In green are the connections shown I need so set up.</P><P>I need to connect Werke.wID with {Derivate.wID AND Derivate1.wID AND Derivate2.wID AND Derivate3.wID}.</P><P>Joining the tables will exceed my RAM. Is there a work around?</P></BODY></HTML> Wed, 09 Jan 2013 16:14:58 GMT 2013-01-09T16:14:58Z Joining Tables https://community.qlik.com/t5/QlikView/Joining-Tables/m-p/409039#M565967 <HTML><HEAD></HEAD><BODY><P>Hi folks,</P><P></P><P>I have the data structure shown in the picture. In green are the connections shown I need so set up.</P><P>I need to connect Werke.wID with {Derivate.wID AND Derivate1.wID AND Derivate2.wID AND Derivate3.wID}.</P><P>Joining the tables will exceed my RAM. Is there a work around?</P></BODY></HTML> Wed, 09 Jan 2013 16:14:58 GMT https://community.qlik.com/t5/QlikView/Joining-Tables/m-p/409039#M565967 2013-01-09T16:14:58Z Re: Joining Tables https://community.qlik.com/t5/QlikView/Joining-Tables/m-p/409040#M565968 <HTML><HEAD></HEAD><BODY><P>Your Werke table has only two fields? Then you could use it as a mapping table and use applymap to add Standort to the four Derivat tables. You will no longer need the Werke table anymore. You can also transform you NAELs table with the crosstable function or a bunch of concatenates to another form so you create a record for each Derivat instead of keeping all four of them in one record. This makes the next step possible. Next concatenate all your Derivat tables into one Derivaten table. The result will look like this:</P><P></P><P><IMG __jive_id="28928" alt="comm69894_2.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/28928_comm69894_2.png" /></P><P>You'll only have two tables left, but still all the information.</P><P></P><P>The Source field in Derivaten is used to store from which source table the Derivat record came.</P></BODY></HTML> Wed, 09 Jan 2013 18:27:20 GMT https://community.qlik.com/t5/QlikView/Joining-Tables/m-p/409040#M565968 Gysbert_Wassenaar 2013-01-09T18:27:20Z