What is a link table??

[nikhilgarg]

Hey,

Can anyone tell me what is a link table and how it is used ??

Thanks

[richard_pearce6]

Interview question?

A table purley of keys linking two or more fact tables.

Richard

Qlikcentral.com

[#3]

hi,

linktable is resloving tha synthatic keys  & loops.

syn:

For Eample :

                   sno&', '&name&' ,' as Name

actuval table:

@

sno name

1   hh

2   mm

3   nn

4   gg

5   ll

Result:

Name

1,hh

2,mm

3,nn

4,gg

5,ll

***

When u have Multiful Fact tables in qlikview we can use linktable. when u they are joined with different Dimension table  that time we 'll use linktable.

[nikhilgarg]

Hey,

How can i make link table??

Can you please tell.

Thanks.

[richard_pearce6]

usually you would re-load tables you have and join / concat them in a way to create the link table.

[ychaitanya]

Refer to Link table

[jagan]

Hi,

Check below script

Fact1:

LOAD

Dim1 & '_' & Dim2 & '_' &Dim3 AS Key,

Measure1,

Measure2

FROM FactTable1;

Fact2:

LOAD

Dim1 & '_' & Dim2 & '_' &Dim3 AS Key,

Measure3,

Measure4

FROM FactTable2;

LinkTable:

LOAD DISTINCT

Dim1 & '_' & Dim2 & '_' &Dim3 AS Key,

Dim1,

Dim2,

Dim3

FROM FactTable1;

Concatenate(LinkTable)

LOAD DISTINCT

Dim1 & '_' & Dim2 & '_' &Dim3 AS Key,

Dim1,

Dim2,

Dim3

FROM FactTable1

WHERE NOT Exists(Key, Dim1 & '_' & Dim2 & '_' &Dim3);

Hope this helps you.

Regards,

Jagan.

[er_mohit]

Have a look to this

DailyQV: Link tables

[sujeetsingh]

Link tables are used to link two tables with multiple key like a bridge.

[er_mohit]

Have a look to this

DailyQV: Link tables