link table

vikasmahajan — Fri, 25 Aug 2023 09:38:49 GMT

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

Re: link table

Vadimb — Thu, 14 Dec 2023 09:11:59 GMT

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];

article link table in Qlik Sense Documents

link table

Re: link table