topic Case 701 :- After adding GL Table i get one or more loop have been detected error msg in QlikView

Case 701 :- After adding GL Table i get one or more loop have been detected error msg

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

Hi All

I get error msg :-

One or more loops have been detected in your database structure. Loops may cause ambiguous results and should therefore be avoided. QlikView will cut the loop(s) by setting one or more tables as loosely coupled. Settings for loosely coupled tables can be modified after script execution in the tables page of the document properties dialog.

If i change below red color field name to SOURCE_1 , The above error msg will disappear. But i cannot change this field name.

For Each i in '$(vFile2010)','$(vFile2011)','$(vFile2012)','$(vFile2013)','$(vFile2014)'
LOAD
'$(i)' as SOURCE_,
Date( Date#([Posting Date], 'MM/DD/YYYY'), 'DD/MM/YYYY') as [date],
[GL Code] as GL_CODE_,
[GL Code] as GL_CODE,

Below is my data model :-

May i know how can i solve my problem beside modify my field name ?

Paul

Re: Case 701 :- After adding GL Table i get one or more loop have been detected error msg

Saravanan_Desingh — Sun, 24 May 2020 13:27:30 GMT

This is circular reference. Make sure there are no two paths between two tables.

In your model, you have to review SOURCE and date fields.

Re: Case 701 :- After adding GL Table i get one or more loop have been detected error msg

paulyeo11 — Sun, 24 May 2020 13:32:30 GMT

Thank you very for your sharing .

Re: Case 701 :- After adding GL Table i get one or more loop have been detected error msg

paulyeo11 — Wed, 27 May 2020 10:30:29 GMT

Hi Saran

https://community.qlik.com/t5/QlikView-Scripting/Cases-848-if-241-248T-2-134-147T-1-134-147T-as-sales/m-p/1705148#M99230

Can you advise me on above link. The expression I cannot make it work.

Paul