Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey,
Can anyone tell me what is a link table and how it is used ??
Thanks
Interview question?
A table purley of keys linking two or more fact tables.
Richard
Qlikcentral.com
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.
Hey,
How can i make link table??
Can you please tell.
Thanks.
usually you would re-load tables you have and join / concat them in a way to create the link table.
Refer to Link table
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.
Have a look to this
Link tables are used to link two tables with multiple key like a bridge.
Have a look to this