link table

[vikasmahajan]

Link Table :

Please find simple link table concept implemented with multiple fact tables. Hope definitely help new comers will help to clear concept of link tables.

Data Modelling is technique in qlik for linking tables we can use link tables concept please refer ppt .

Qlik Tips: Rules for creating a Key/Link Table in QlikView and this post

Re: Advantages of Link Table;

ref: https://www.analyticsvidhya.com/blog/2014/12/remove-synthetic-key-concatenation-link-table-qlikview/

Please find attached excel & data model containing how to implement a link table.

Attached Solution Linktable2

Hope this help to new comers.

Thanks

Vikas

[Vadimb]

Hi,

Thank you for the information.
What are the pros and cons of using a concatenate instead of a join?

for example

[LinkTable_20]:
LOAD Distinct
[Company.id] AS [_Company.id_KEY]
RESIDENT [Company];
JOIN
LOAD Distinct
[Projects.CompanyInitiatesId] AS [_Company.id_KEY]
,[Projects.id] AS [_Projects.id_KEY]
RESIDENT [Projects];
JOIN
LOAD Distinct
[Requests.IInitiatingCompanyId] AS [_Company.id_KEY]
,[Requests.UsrProjectId] AS [_Projects.id_KEY]
,[Requests.id] AS [_Requests.id_KEY]
RESIDENT [Requests];
JOIN
LOAD Distinct
[Applications.UsrProjectCompanyInitiateId] AS [_Company.id_KEY]
,[Applications.UsrProjectId] AS [_Projects.id_KEY]
,[Applications.RequestId] AS [_Requests.id_KEY]
,[Applications.id] AS [_Applications.id_KEY]
RESIDENT [Applications];

[LinkTable]:
NoConcatenate
LOAD Distinct *
,[_Company.id_KEY] AS [_Full_Company_Key_DDF]
,[_Company.id_KEY] &' | '& [_Projects.id_KEY] AS [_Full_Projects_Key_DDF]
,[_Company.id_KEY] &' | '& [_Projects.id_KEY] &' | '& [_Requests.id_KEY] AS [_Full_Requests_Key_DDF]
,[_Company.id_KEY] &' | '& [_Projects.id_KEY] &' | '& [_Requests.id_KEY] &' | '& [_Applications.id_KEY] AS [_Full_Applications_Key_DDF]
RESIDENT [LinkTable_20];
DROP TABLE [LinkTable_20];