Joining multiple tables - Best Practice

[bharani8]

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..

[techvarun]

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.

[its_anandrjs]

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

[Siva_Sankar]

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

[bharani8]

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

[its_anandrjs]

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%20D...

[its_anandrjs]

Even this is the best

Star Schema or Snow Flaxe schema?

[Siva_Sankar]

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