loops error

[#1]

hello i got this message of loops problem any suggestions how to fix a loop problem ,

i have alot of script lines....

[#2]

this might indicate the problem?

[oknotsen]

Loops are not allowed in your data model.

So either cut the key connection between any 2 of the 3 tables or see if you can join those 2 dimensions.

[reddy-s]

Hi Jhonatan,

You can get rid of circular references by renaming the SALES_KEY field in the INV_SALES table if you do not need an association between them.

Instead you can even join the CUSTOMERS table and the INV_SALES table together and create a composite key to join it to the KEY_TABLE.

There is a lot to say here so please go through this document : Circular References by HIC.

- Sangram

[Josh_Good · Accepted solution]

Hi,

This video by mto‌ should help explain what is happening.

You may also wish to take a look at Creating a Data Model‌

-Josh

Qlik