applymap

[raadwiptec]

my source is something as below.

country  Marketing head

india        samson

france      ken

italy          rosh

india         patel

when i do an applymap.. i get for india only one value Ken and not th e other.. any suggestion

[sravanthialuval]

Hi,

Please post sample script then we will let you know.

[fvelascog72]

Hi,

Maybe you need a left join, but you will duplicate registers.

Cheers

[omkarvamsi]

can you please elaborate a bit

[stabben23]

When you use applymap there should be distinct values from maptable, you have here 2 India, what do you expect for output when India is mapped?

[terrorthijs]

Applymap can only handle the translation of 1 input value to 1 output value, so this seems like a situation in which it shouldn't be used.

By the way: it would seem like for India the value would become Samson, not Ken?

[fvelascog72]

In attached file you can see the difference.

[stabben23]

A great example on why left join shouldn't be used. Increase sales on every salesman from india

[raadwiptec]

iam expecting both samson and ken..

[stabben23]

, No you dont! Have a look at your data.