Loops when loading a file.

[#1]

Hi can someone please help me to resolve the error below? I am getting it when reloading the file.

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

Kind regards

Edzi

[Anonymous]

ur case d situation may

                   table A  links to  table B links  to  table A

to solve plz rename the feilds which are common... n den proceed to link only those u want....wit common name....

regards,

vaibhav

[SunilChauhan]

better to use

for each table

qualify * ;

unqualify primarykeyfield;

or else you can break a link in database which of list use.

hope this helps

[#4]

Hi

The fields does not have common names, but it seems like the problem is the common values in the fields that I am trying to connect with, I am trying to connect too excel files to a table in the sql database,

Standard Time per Rule is connected using Rule to the SQL table and

Benchmarks per Area is connected using PROCESSING AREA to the SQL table.

Any Idea how to resolve this?

Thanks

Edzi

The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorised. If you are not the intended recipient any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful

[#5]

Hi

The fields does not have common names, but it seems like the problem is the common values in the fields that I am trying to connect with, I am trying to connect too excel files to a table in the sql database,

Standard Time per Rule is connected using Rule to the SQL table and

Benchmarks per Area is connected using PROCESSING AREA to the SQL table.

Any Idea how to resolve this?

Thanks

Edzi

The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorised. If you are not the intended recipient any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful

[Anonymous]

hi as per ur given excels i tried loading .....bt itz fine....der isnt any problem in loading (Witout any loops)

wen u r selecting data from tab table file of qlikview make sure y select Embedded labels in label tab....

regards,

Vaibhav

[#7]

Hi

There is an extra table, an SQL table that I have to connect the two excel files with, that’s where I got the problem.

Thanks

Edzi

The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorised. If you are not the intended recipient any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful