Link

[smilingjohn]

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

[Kushal_Chawda]

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

[arvind_patil · Accepted solution]

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

[ravikumar_iyana]

Hi

Link Table using for separating Facts purpose