Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
manoranjan_d
Specialist
Specialist

Join or mapping

Hi join is fast or mapping is fast according to performance wise?

6 Replies
Anil_Babu_Samineni

I know, you may have some ideas. But read this, You may get to know which is best performance function

Don't join - use Applymap instead

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
mbrdenmark
Contributor III
Contributor III

Joins are generally faster than applymap in terms of raw performance.

Source: QlikView Developer course

prma7799
Master III
Master III

The reason I  have used applymap a lot is (as opposed to join)

  • It only picks up the first record. (although not exists can be used to eliminate multi records but I feel its safer using applymap  when a second entry for one record must be ignored)
  • Missing records can be given a name. Like 'Missing' . Or can be used to group records. So an excel spreadsheet will have the Focus Customers and the rest will be grouped as 'Other

The disadvantage are

  • applymap can only loookup one record. Say the Customer name for the Cust Number but not also the Cust Telephone number. Unless another apply map is used
  • Its more work to set up. Join is simple

Please go through below links

Mapping Load / Apply Map versus Left Join

Don't join - use Applymap instead

prieper
Master II
Master II

Fully support PM and am also very much in favour of APPLYMAP().

One small thing to add: Applymap does not cause an error, if reference-tables are not existings / misspelled.

Peter

prma7799
Master III
Master III

manoranjan.d‌ Please close this thread by giving correct or helpful .

Kushal_Chawda

manoranjan.d

Request you to please close the thread by marking answers as correct or helpful. Many of your previous threads are still open even there are helpful answers