Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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..
Hi,
Please post sample script then we will let you know.
Hi,
Maybe you need a left join, but you will duplicate registers.
Cheers
can you please elaborate a bit
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?
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?
In attached file you can see the difference.
A great example on why left join shouldn't be used. Increase sales on every salesman from india
iam expecting both samson and ken..
, No you dont! Have a look at your data.