apply map

[prabhas277]

Hi,

which one is good in qlikview applymap or join?

Please explain the apply map with example? 

[Kushal_Chawda]

see the below link

Don't join - use Applymap instead

[ashfaq_haseeb]

Hi,

Wherever possible go with Applymap().

Regards

ASHFAQ

[jonathandienst]

They serve slightly different purposes.

• ApplyMap is a simple lookup - it is functionally the same as a a Vlookup/Hlookup in Excel.
• Join is analogous to a SQL join, in that you can filter on a join (using LEFT, RIGHT, or INNER), and add extra rows as well as columns, such as in an OUTER join, or where the join table has multiple rows matching the key.

In general, ApplyMap() is the quickest solution, so avoid doing lookups using a join, but use a join when it is appropriate.

[engishfaque]

Dear Prabhas,

Kindly find attached sample App for Applymap.

Please go through listed below link for Joins,

Understanding Join, Keep and Concatenate

Kind regards,

Ishfaque Ahmed

[jagan]

Hi,

ApplyMap() is faster than Join.  If we have more than two columns then we need to join both the tables, otherwise we can use ApplyMap().

So the first priority is ApplyMap()

Regards,

Jagan.

[avinashelite]

It depends on the data model, requirement  and the amount of data that your handling  .....

1.If your working with small data set than JOIN and apply map doesn't have much of the difference

2.If you want to map or recreate only few columns than mapping is better

3. If your using left or right joins than there are changes of losing the records but with apply map you will not lose any records