Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nihhalmca
Specialist II
Specialist II

Loosely Couple Table

Hi All,

When will we use 'Loosen' keyword in edit script.

How it is useful for data modeling. Which scenarios Loosely couple table will use.

Can anybody give examples on this.

Thank you.

Regards,

Nihhal.

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

Hi,

Check this

Table1:

LOAD

*

INLINE [

A, B

1, 2 ];

Table2:

LOAD

*

INLINE [

C, B

1, 2 ];

Table3:

LOAD

*

INLINE [

C, A

1, 2 ];

Loosen Table Table3;

By using Loosen Table Table3; you won't get the error message regarding the circular loop.

Regards,

Jagan.

View solution in original post

9 Replies
PradeepReddy
Specialist II
Specialist II

go through the link...

Re: How to "Loosely Couple" a Table?

Not applicable

Hi,

If you have circular reference in your data model in this case u can use loosen tables.

suppose if you have circular refference between A,B,C

then use this command in the script after load statement of all the tables.

Loosen tables A,B,C;

it will give good performance if you have circular refference also

nihhalmca
Specialist II
Specialist II
Author

Hi Rakesh,

Thanks for response.

Can you give share sample qvw.

jagan
Luminary Alumni
Luminary Alumni

Hi,

Check this

Table1:

LOAD

*

INLINE [

A, B

1, 2 ];

Table2:

LOAD

*

INLINE [

C, B

1, 2 ];

Table3:

LOAD

*

INLINE [

C, A

1, 2 ];

Loosen Table Table3;

By using Loosen Table Table3; you won't get the error message regarding the circular loop.

Regards,

Jagan.

Colin-Albert

If you have "Loosley Coupled" tables, and a circular reference then your data model is incorrect and you should fix the problem by correctly linking the tables.

Using "Loosen" is not a fix for an incorrect data model.

Not applicable

Hi,

Sorry I Dont have any sample application for loosen concept.

nihhalmca
Specialist II
Specialist II
Author

Its Ok Rakesh.

jagan
Luminary Alumni
Luminary Alumni

Hi Nihhal,

Having Loosely coupled tables is not a good practice to avoid Circular loop issue, it is a quick fix but not the efficient one.  Try to avoid loop by using various techniques like Link Table, Concatenate, Renaming field etc.

Hope this helps you.

Regards,

Jagan.

nihhalmca
Specialist II
Specialist II
Author

Hi All,

Just check Loosely couple option after followed by Jagan mohan answer (shown as correct answer). see below steps to check Loosely couple option.

Settings -- Document properties -- table -- check Loosely couple option for required table.

Regards,

Chittibabu.