topic Re: applymap in QlikView

applymap

raadwiptec — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: applymap

sravanthialuval — Tue, 31 Jan 2017 13:09:11 GMT

Hi,

Please post sample script then we will let you know.

Re: applymap

fvelascog72 — Tue, 31 Jan 2017 13:09:24 GMT

Hi,

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

Cheers

Re: applymap

omkarvamsi — Tue, 31 Jan 2017 13:15:32 GMT

can you please elaborate a bit

Re: applymap

stabben23 — Tue, 31 Jan 2017 13:17:24 GMT

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?

Re: applymap

terrorthijs — Tue, 31 Jan 2017 13:24:26 GMT

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?

Re: applymap

fvelascog72 — Tue, 31 Jan 2017 13:26:57 GMT

In attached file you can see the difference.

Re: applymap

stabben23 — Tue, 31 Jan 2017 13:37:20 GMT

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

Re: applymap

raadwiptec — Tue, 31 Jan 2017 14:04:55 GMT

iam expecting both samson and ken..

Re: applymap

stabben23 — Tue, 31 Jan 2017 14:09:59 GMT

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

Re: applymap

Peter_Cammaert — Tue, 31 Jan 2017 14:11:42 GMT

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

Re: applymap

buzzy996 — Tue, 31 Jan 2017 14:26:08 GMT

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.

Re: applymap

raadwiptec — Wed, 01 Feb 2017 07:43:37 GMT

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