Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
raadwiptec
Creator II
Creator II

applymap

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

1 Solution

Accepted Solutions
raadwiptec
Creator II
Creator II
Author

guys this is fixed now... i tried loading as a seperate table itself with no concatenate..but applymap in pra ctical was not working...for the above scenario..

View solution in original post

12 Replies
sravanthialuval
Creator
Creator

Hi,

Please post sample script then we will let you know.

fvelascog72
Partner - Specialist
Partner - Specialist

Hi,

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

Cheers

omkarvamsi
Creator
Creator

can you please elaborate a bit

stabben23
Partner - Master
Partner - Master

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
Partner - Contributor II
Partner - Contributor II

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
Partner - Specialist
Partner - Specialist

In attached file you can see the difference.

stabben23
Partner - Master
Partner - Master

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

raadwiptec
Creator II
Creator II
Author

iam expecting both samson and ken..

stabben23
Partner - Master
Partner - Master

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