topic Re: Link in QlikView

Link

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Can someone please explain me how does the LINK Table works and also what is the use of no concatenate....

I mean were is exactly used ...

Thanks in advance

Re: Link

Kushal_Chawda — Wed, 27 Sep 2017 07:10:02 GMT

Two simple rules for creating Link tables and concatenate Fact tables are

1) If you Fact tables are available at the same granularity, then go for concatenate Fact tables.

2) If your Fact tables are available at different granularity then go for Link tables.

for eg. One Fact is available at Year level, and Second Fact is available at month level, then create link table

To know, how to create link tables, refer to this link

Concatenate vs Link Table

Re: Link

arvind_patil — Wed, 27 Sep 2017 07:17:56 GMT

Hi John,

I will try to explain in short:

Link tables are generally used for linking the two table or the fact tables.

As we know that when we are designing the datamodel synthetic keys and circular loop are common.

For fixing this problems we use the link table concept.

No Concatenate:

if filed names are same in two tables then they are auto concatenate while there table names are different so in this case if we drop one table automatically drop another. so noconcatenate keep both separately.

For more in detail follw below link:

https://community.qlik.com/blogs/qlikviewdesignblog/2013/05/17/concatenate-vs-link-table‌

How to create Link Table??‌

when do we use noconcatenate in our data model | Qlik Community

Thanks,

Arvind Patil

Re: Link

ravikumar_iyana — Wed, 27 Sep 2017 14:15:06 GMT

Link Table using for separating Facts purpose