

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Joining multiple tables - Best Practice
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..


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It depends on the table size and joining key on your data model.
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you All for taking ur time to respond on this!! Appreciated!!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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/

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Even this is the best


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
