How to fix a loop in QlikView upload

[leale1997]

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.

[leale1997]

This is the translation table linking the two information tables.

[Brett_Bleess]

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