Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
KennyStevens
Contributor
Contributor

How to avoid circular reference with a generic table.

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?
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.

KennyStevens_0-1619169697813.png

KennyStevens_1-1619170415721.png

 

1 Reply
rubenmarin
MVP
MVP

Hi Kenny, there is an article in design blog where it's explained: https://community.qlik.com/t5/Qlik-Design-Blog/The-Generic-Load/ba-p/1473470