Need to know why to use ApplyMaps over joins

[deepali_more]

Hello All,

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

[varshavig12]

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

Regards

Varsha

[deepali_more]

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]

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