
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Joins Vs Applymap
hi,
I have small confusion between Applymap() and joins?
I think in applymap() a small drawback is there
what applymap() do, we can do by the joins and drop the table.
my idea is We can use the join to bring one filed to another table and drop the table.
in applymap() every time it looks into the table and it takes more time than a join so join is good?
is it correct?
i wan difference between applymap and join;
thanks in advance
venu
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Join is better than Mapping but depends on the model some where mapping is better.
Hope this helps
Thanks & Regards

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Venu, Please see this blog from HC.
http://community.qlik.com/blogs/qlikviewdesignblog/2012/09/18/one-favorite-function-applymap

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It is always good practice using joins all data is reside in on single data source in developer's point of view where us when if there is specific requirement occurs in this scenario you should use apply map also
go through this discussion
Mapping Load / Apply Map versus Left Join
hope this help you.
Vikas
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Join is better than Mapping
Hope this helps
Thanks & Regards


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Applymap is for the Reference lookup type of requirement.
The Mapping load only takes two fields in the table.
However Join can be used if you want to select a result set of the source tables.
Joins can work on more than one Field and their values with four types(outer, inner,left and right).

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Join is better than Mapping but depends on the model some where mapping is better.
Hope this helps
Thanks & Regards

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It all comes down to how much data you want to combine. A JOIN is very flexible / powerful but also a resource hog. Mapping tables are extremely fast but you won't experience any improvement on small data sets.
Most long-time QlikView developers tend to prefer applymap to any JOIN simply because of its efficiency. When a document has to be reloaded in a densely populated QDS environment, every second and every MB saved is crucial for achieving optimal performance.
To summarize:
- Avoid JOINs, especially on large data sets. You can knock out your server with an audacious JOIN, often leading to the dreaded "General Script Error".
- Use Applymap() for conversions and translations of single fields, or multiple Mapping tables for multiple fields in large data sets (currencies?)
- Use Lookup() is you want to get values from different columns in an existing table. It's not as fast as applymap() but way faster in many cases than a Join.
- You can even use ApplyMap() instead of Exists() in a WHERE clause, and performance will often improve. But that depends on the situation.
There is no absolute thruth that tells you when to use this, and when to use that technique. You should always try what you think is best. That's a good way to develop your "Fingerspitzengefühl" (aka QlikView Experience)
Good luck,
Peter

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi Ravi Shankar Paramaramaraj can you say in your word hw applymap is better please/... thanks in Advance
venu

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Venu,
first of all its upto requirment. whenever possible its better to go for Applymap
bcoz, when u compare the performance of Applymap and join (big data). Applymap perform better
