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

[paulyeo11]

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 

[Saravanan_Desingh · Accepted solution]

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.

[paulyeo11]

Thank you very for your sharing .

[paulyeo11]

Hi Saran

https://community.qlik.com/t5/QlikView-Scripting/Cases-848-if-241-248T-2-134-147T-1-134-147T-as-sale...

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

Paul