One or more loops have been detected in your database structure.

[#1]

Hi

    I have attached the excel with three sheets. My First Sheet contains Master. Second sheet Contains Phone Calls. Third Sheet contains Sales Value. If i link it shows an error like One Or More 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.

Linking given as

Load *, Name as Key,Master Code as Key2 Resident Master;

Drop Table Master;

Load *, Name as Key ,Dt as Key3 Resident Phone_Calls;

Drop Table Phone_Calls;

Load *, Master Code as Key2 ,Dt as Key3 Resident Sales;

Drop Table Sales;

Please Help me to Solve this issue ASAP

Sakthi

[#2 · Accepted solution]

Hi,

In your datamodel the association between 3 tables formed a circuler (Circular reference). So, you should put alias names for your fields. See the below load statements:

LOAD Name AS MasterName,
     [Master Code]
FROM
MyFiles.xlsx
(ooxml, embedded labels, table is Master);

LOAD Name as MasterName,
     Dt as CallsDate,
     [Phone Calls]
FROM
MyFiles.xlsx
(ooxml, embedded labels, table is Phone_Calls);

LOAD Master,
     [Master Code],
     Dt as SalesDate,
     Sales
FROM
MyFiles.xlsx
(ooxml, embedded labels, table is Sales);