topic Re: Applymap? in QlikView

Applymap?

Wed, 30 Jul 2014 06:51:00 GMT

load * inline [

empid,salary

1,1000

2,2000

3,3000

4,4000

5,5000

];

load * inline [

empid,salary,name,account

1,1000,ramesh,sbi

2,2000,rajesh,icici

];

if i write applymap in using emp id (applymap('A','empid') as salary) what about emp id 3,4,5 whether it will map or igonre ? what will be the output?

Re: Applymap?

Anonymous — Wed, 30 Jul 2014 06:55:45 GMT

Hi,

ApplyMap will only map those ids which part of table B, just like left join. 3,4 and 5 will ignore from loading.

Re: Applymap?

SunilChauhan — Wed, 30 Jul 2014 06:59:52 GMT

applymap('A','empid','Blank')

here blank will be assign to other id than matching

see applymap in help for more details

hope this helps

Re: Applymap?

tobias_klett — Wed, 30 Jul 2014 07:01:18 GMT

Hi,

applymap does have a "else" for defaults.
applymap('A',empid,'No salary found for ' & empid) as salary

Hope this helps
Tobias

Re: Applymap?

ngulliver — Wed, 30 Jul 2014 08:16:16 GMT

If you need to understand more about ApplyMap, have a look at Steve Dark's blog:

http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/

Cheers,

Neil

Re: Applymap?

SunilChauhan — Wed, 30 Jul 2014 08:18:13 GMT

applymap('A',empid,'Blank')

here blank will be assign to other id than matching

see applymap in help for more details

hope this helps