topic Linktable in QlikView

Linktable

prabhas277 — Mon, 01 Jun 2015 02:20:41 GMT

Hi Experts,

What is linktable? what is the use of link table and when we go for linktable? explain with suitable scinerio?

Regards

prabhas

Re: Linktable

Anonymous — Mon, 01 Jun 2015 04:08:51 GMT

Hi Prabhas,

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

Let us go with an example..

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

For fixing this problems we use the link table concept.

You can also use concatenation ,but it always not give the appropriate result.

Concatenation works well enough when we have all the fields same.

With the use of link tables, it’s possible to keep the fact tables separated from each other. The advantage of this solution for choosing this method is to keep the data model a logical one.

For better understand check the below link:

Link Table in QlikView | Learn QlikView

Re: Linktable

PrashantSangle — Mon, 01 Jun 2015 04:26:03 GMT

Read below thread most of concept of link table is cover in this thread.

LinkTable

Regards

Re: Linktable

Anonymous — Mon, 01 Jun 2015 05:07:51 GMT

Check out this Link

Link Table in QlikView | Learn QlikView

Re: Linktable

Anonymous — Mon, 01 Jun 2015 07:25:45 GMT

Hi,

Link table used for removing synthetic keys.

Go to this link ,. You will get example as well as how to load link table.

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

Thanks

BKC