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: 
prabhas277
Creator
Creator

Link table

Hi experts,

what is the link table? when we go for link table? explain with example?

5 Replies
Chanty4u
MVP
MVP

prma7799
Master III
Master III

HirisH_V7
Master
Master

Hi,

Links tables are used In Qlikview,When You come across a situation where you have to handle multiple Fact tables, which in turn create synthetic keys or Circular references(Loops).

Link Table is a very useful way to resolve synthetic keys and Circular references(Loops) when multiple fact tables are present in the data model.

Link table is used, when the granularity of the facts tables are different and when they are joined to different dimensions.

To resolve these synthetic keys Link table:

  • You should always load Distinct records while creating Link table. Also if the Key field/composite field contains several individual fields then it is good to create Key field
  • Create a composite key. Using Auto number ( ) function like:
  • AutoNumber(YEAR&’|'&CUSTOMER_KEY&’|'&PRODUCT_KEY) As [%Key field]
  • Link table can connect to the original fact tables using this composite Key
  • Load all the common fields in one table called Link table
  • Drop these fields from the original tables.

HTH,

Hirish

HirisH
“Aspire to Inspire before we Expire!”
avinashelite

check this link for the complete inforamtion

untitled.png

Link Table in QlikView | Learn QlikView