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

[Peter_Cammaert]

In case you use

LOAD ...

     Applymap('MapCountries', Country, 'None') AS MarketingMan,

     ...

FROM ...;

there is no room for two values in MarketingMan. What should happen here?

You could change your mapping table to return a string of concatenated heads, like

Country  Marketing head

india    samson, patel

france   ken

italy    rosh

:

Best,

Peter

[buzzy996]

hi,as per ur data ken not from india, so not sure how u got the same.

if possible share sample app,that helps to solve your problem in a minute.

[raadwiptec · Accepted solution]

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..