Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
deepali_more
Creator
Creator

Need to know why to use ApplyMaps over joins

Hello All,

I am bit confused in the use of applymaps and joins. what  to prefer over and Why??

13 Replies
varshavig12
Specialist
Specialist

If you got your answer , you can mark it correct and close the thread.

Regards

Varsha

deepali_more
Creator
Creator
Author

Thanks Nakul!!

avinashelite

if you have got the answers please mark the helpful and correct answers so that it will be helpful for others

hic
Former Employee
Former Employee

Joins can potentially duplicate records, thus creating a table with incorrect numbers. Applymap() is in almost all cases the better choice: Faster and less error prone.

See more on Don't join - use Applymap instead

HIC