Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I have three tables in my data model. Two of the tables contain analytical information. One of the tables is designed to tie the two information tables together by reconciling naming conventions for a field both tables have in common. The reconciliation table is creating a loop that I am not sure how to fix. I know that I need to qualify or concatenate. I'm just not sure what the easiest way to do it in this situation is. Please see attachments.
Thanks in advance for the assist.
This is the translation table linking the two information tables.
The following Design Blog posts should prove useful:
https://community.qlik.com/t5/Qlik-Design-Blog/Circular-References/ba-p/1469332
https://community.qlik.com/t5/Qlik-Design-Blog/Synthetic-Keys/ba-p/1472634
https://community.qlik.com/t5/Qlik-Design-Blog/Concatenate-vs-Link-Table/ba-p/1467569
Hopefully those will get you on the right track.
Regards,
Brett