Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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];
@Vadimb there exists an excellent technical brief on this topic. Basically in my use cases it generally boiled down to performance (concatenate generally is better) vs. understandability (link generally is better).
If you want a more detailed comparison of the two options, I recommend you reading the technical brief "QlikView Technical Brief - Concatenate and Link tables".
I was not able to attach the document to my comment, but you should find it easily by googling.
Best regards,
Benjamin