https://community.qlik.com/t5/App-Development/How-to-avoid-circular-reference-with-a-generic-table/m-p/1802087#M65067 <P>In the following datamodel I have a generic table with the descriptions of codes incorporated in almost each other table in 3 languages. How can I easily join/associate those descriptions to the different tables?<BR />If I just use the generic function, it works to create the associations I want, but it also creates a lot of circular references and a syn key as you see below.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="KennyStevens_0-1619169697813.png" style="width: 787px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/53544i41DC0E504FE22409/image-dimensions/787x468?v=v2" width="787" height="468" role="button" title="KennyStevens_0-1619169697813.png" alt="KennyStevens_0-1619169697813.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="KennyStevens_1-1619170415721.png" style="width: 822px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/53549i5AB7EEAA9E5A1E28/image-dimensions/822x603?v=v2" width="822" height="603" role="button" title="KennyStevens_1-1619170415721.png" alt="KennyStevens_1-1619170415721.png" /></span></P><P>&nbsp;</P> Fri, 23 Apr 2021 09:34:51 GMT KennyStevens 2021-04-23T09:34:51Z https://community.qlik.com/t5/App-Development/How-to-avoid-circular-reference-with-a-generic-table/m-p/1802087#M65067 <P>In the following datamodel I have a generic table with the descriptions of codes incorporated in almost each other table in 3 languages. How can I easily join/associate those descriptions to the different tables?<BR />If I just use the generic function, it works to create the associations I want, but it also creates a lot of circular references and a syn key as you see below.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="KennyStevens_0-1619169697813.png" style="width: 787px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/53544i41DC0E504FE22409/image-dimensions/787x468?v=v2" width="787" height="468" role="button" title="KennyStevens_0-1619169697813.png" alt="KennyStevens_0-1619169697813.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="KennyStevens_1-1619170415721.png" style="width: 822px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/53549i5AB7EEAA9E5A1E28/image-dimensions/822x603?v=v2" width="822" height="603" role="button" title="KennyStevens_1-1619170415721.png" alt="KennyStevens_1-1619170415721.png" /></span></P><P>&nbsp;</P> Fri, 23 Apr 2021 09:34:51 GMT https://community.qlik.com/t5/App-Development/How-to-avoid-circular-reference-with-a-generic-table/m-p/1802087#M65067 KennyStevens 2021-04-23T09:34:51Z https://community.qlik.com/t5/App-Development/How-to-avoid-circular-reference-with-a-generic-table/m-p/1802352#M65088 <P>Hi Kenny, there is an article in design blog where it's explained:&nbsp;<A href="https://community.qlik.com/t5/Qlik-Design-Blog/The-Generic-Load/ba-p/1473470" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/The-Generic-Load/ba-p/1473470</A></P> Sat, 24 Apr 2021 07:35:55 GMT https://community.qlik.com/t5/App-Development/How-to-avoid-circular-reference-with-a-generic-table/m-p/1802352#M65088 rubenmarin 2021-04-24T07:35:55Z