topic Re: Joining multiple tables - Best Practice in QlikView

Joining multiple tables - Best Practice

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

Hi Experts - Need your opinion what is the best practice when we join multiple tables (more than 5 tables) in qlikview? I mean, By which we should join and by which we should not join... like those things... Bcoz am getting confused sometimes due these... Appreciate your explanation on this..

Re: Joining multiple tables - Best Practice

techvarun — Thu, 19 Oct 2017 06:32:30 GMT

It depends on the table size and joining key on your data model.

Joins and Lookups

Combining tables with Join and Keep ‒ QlikView

Understanding Join, Keep and Concatenate

http://www.qlikfix.com/2011/02/07/merging-tables-the-join-prefix/

QlikView Addict: Explaining Joins

Read the above links to understand.

Re: Joining multiple tables - Best Practice

its_anandrjs — Thu, 19 Oct 2017 06:35:07 GMT

It depends on your requirement or data model but when you join to table then the base is Keys / Primary keys / composite keys and while you concatenate more fields same or all fields same.

Some Qlikview Joins,Keep,Concatenation and Applymap best documents

Qlikview

Re: Joining multiple tables - Best Practice

Siva_Sankar — Thu, 19 Oct 2017 08:07:18 GMT

Hi Bharani,

Read these two from an expert and i hope it is more appropriate for your question To Join or not to Join and Don't join - use Applymap instead

-Siva

Re: Joining multiple tables - Best Practice

bharani8 — Thu, 19 Oct 2017 09:29:41 GMT

Thank you All for taking ur time to respond on this!! Appreciated!!

Re: Joining multiple tables - Best Practice

its_anandrjs — Thu, 19 Oct 2017 09:39:04 GMT

I suggest you best way is to read about the data modelling concept as well

Best Practices for Data Modelling

https://community.qlik.com/thread/84010‌

Get started with developing qlik datamodels

http://www.quickintelligence.co.uk/perfect-your-qlikview-data-model/‌

https://community.qlik.com/servlet/JiveServlet/previewBody/7343-102-1-9596/Best%20Practices%20in%20Data%20Modeling.pdf?_…

Re: Joining multiple tables - Best Practice

its_anandrjs — Thu, 19 Oct 2017 09:40:24 GMT

Even this is the best

Star Schema or Snow Flaxe schema?

Re: Joining multiple tables - Best Practice

Siva_Sankar — Thu, 19 Oct 2017 09:42:32 GMT

Though there are many recommendations, I suggest you to join first two tables and check the data for any duplicates or missing values and then join by adding third table, 4th and 5th and so on.

This way you will make sure that all the necessary data are loaded properly.

-Siva