topic Re: Loosely Couple Table in QlikView

Loosely Couple Table

nihhalmca — Fri, 14 Nov 2014 10:17:28 GMT

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.

Re: Loosely Couple Table

PradeepReddy — Fri, 14 Nov 2014 10:39:03 GMT

go through the link...

Re: How to "Loosely Couple" a Table?

Re: Loosely Couple Table

Fri, 14 Nov 2014 11:01:48 GMT

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

Re: Loosely Couple Table

nihhalmca — Fri, 14 Nov 2014 11:10:11 GMT

Hi Rakesh,

Thanks for response.

Can you give share sample qvw.

Re: Loosely Couple Table

jagan — Fri, 14 Nov 2014 14:11:41 GMT

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.

Re: Loosely Couple Table

Colin-Albert — Fri, 14 Nov 2014 14:16:55 GMT

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.

Re: Loosely Couple Table

Fri, 14 Nov 2014 14:40:46 GMT

Hi,

Sorry I Dont have any sample application for loosen concept.

Re: Loosely Couple Table

nihhalmca — Tue, 18 Nov 2014 13:07:03 GMT

Its Ok Rakesh.

Re: Loosely Couple Table

jagan — Wed, 19 Nov 2014 01:56:53 GMT

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.

Re: Loosely Couple Table

nihhalmca — Wed, 19 Nov 2014 07:03:11 GMT

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.