topic How to fix a loop in QlikView upload in QlikView

How to fix a loop in QlikView upload

leale1997 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: How to fix a loop in QlikView upload

leale1997 — Wed, 23 Sep 2020 17:38:50 GMT

This is the translation table linking the two information tables.

Re: How to fix a loop in QlikView upload

Brett_Bleess — Tue, 20 Oct 2020 14:55:37 GMT

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