topic Re: Architecture to avoid loops in QlikView https://community.qlik.com/t5/QlikView/Architecture-to-avoid-loops/m-p/420188#M1159622 <HTML><HEAD></HEAD><BODY><P>Can you point me to the documentation on the Link table model?&nbsp; </P></BODY></HTML> Mon, 25 Feb 2013 20:09:43 GMT 2013-02-25T20:09:43Z Architecture to avoid loops https://community.qlik.com/t5/QlikView/Architecture-to-avoid-loops/m-p/420186#M1159620 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am facing the following problem (see attached diagram).</P><P>I have 2 systems (SysA and SysB) with some databases (SQL and MySQL).</P><P>Both have tables related to users and projects.</P><P>Both contain different information (ie one table has the user name while the other has its telefon number) and I would like to aggregate that.</P><P></P><P>I already 'joined' the projects tables using the AS keyword to rename the key in both project tales.</P><P>Now I would like to do the same with the users but it creates loops.</P><P></P><P>What is the best approch to handle this?</P></BODY></HTML> Fri, 08 Feb 2013 17:08:14 GMT https://community.qlik.com/t5/QlikView/Architecture-to-avoid-loops/m-p/420186#M1159620 2013-02-08T17:08:14Z Re: Architecture to avoid loops https://community.qlik.com/t5/QlikView/Architecture-to-avoid-loops/m-p/420187#M1159621 <HTML><HEAD></HEAD><BODY><P>Whenever I have an association challenge like this, I turn to the Link Table model.&nbsp; It has yet to fail me in the most complex association situations.</P></BODY></HTML> Mon, 11 Feb 2013 21:39:49 GMT https://community.qlik.com/t5/QlikView/Architecture-to-avoid-loops/m-p/420187#M1159621 hallquist_nate 2013-02-11T21:39:49Z Re: Architecture to avoid loops https://community.qlik.com/t5/QlikView/Architecture-to-avoid-loops/m-p/420188#M1159622 <HTML><HEAD></HEAD><BODY><P>Can you point me to the documentation on the Link table model?&nbsp; </P></BODY></HTML> Mon, 25 Feb 2013 20:09:43 GMT https://community.qlik.com/t5/QlikView/Architecture-to-avoid-loops/m-p/420188#M1159622 2013-02-25T20:09:43Z