topic Re: Link Table in QlikView

Re: Link Table

senpradip007 — Tue, 22 Jan 2013 05:44:30 GMT

Hi Experts,

I'm new in qlikview. So can any one help me "When should we use a link table in qlikview?".

Thanx in advance.

Pradip

Re: Link Table

khadeer — Tue, 22 Jan 2013 05:52:15 GMT

Hi Pradeep,

Link tables are generally used for linking the two table or the fact tables.

Let us go with an example..

As we know that when we are designing the datamodel synthetic keys and circular loop are common.

For fixing this problems we use the link table concept.

You can also use concatenation ,but it always not give the appropiate result.

Concatenation works well enough when we have all the fields same.

With the use of link tables, it’s possible to keep the facttables separated from each other. The advantage of this solution for choosing this method is to keep the datamodel a logical one.

see the below link it helps u more

http://www.quickqlearqool.nl/?p=910

Re: Link Table

Tue, 22 Jan 2013 05:55:21 GMT

Hi PRADIP SEN

See the attached files.

The file called wrong is how it is not suppose to look like and the file called right is how it should look like. So if your table structure is the same as the "Wrong" image,you need to change it.

Hope it helps

Hein.ITR

Re: Link Table

er_mohit — Tue, 22 Jan 2013 05:57:36 GMT

for creating a loop to define data from one table to another make sure of primary key

we use link table to define data of one table to another... to reduce redundancy.......

with help of

Using an OUTER JOIN in the key table resolved the issue. Concatenate resulted in multiple rows for each index