How to remove Loops may cause ambiguous results ....?

[#1]

Hi  Forums,

Can you please advice how to remove the following error. FYI, It is get generated after re-Load of the script. Note: Already there is Link Table as LinkTab. But I am creating one more Link Table as LinkTab2.

"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."

It will be highly appreciable. If I get solution quickly.

Thanks

SD

[ankitaag]

It means that a circular loop is creating in your datamodel.

Identify which linking is not required, break the non-required link by aliasing them

This way your loops will get removed

[ramoncova06]

this post from HIC contains information regarding circular references

Circular References

[ali_hijazi]

review the names of the columns of your table try to have a star or snow flake schema