Applymap?

[#1]

A:

load * inline [

empid,salary

1,1000

2,2000

3,3000

4,4000

5,5000

];

B:

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? 

[Anonymous]

Hi,

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

[SunilChauhan]

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

here blank will be assign to other id than matching

see applymap in help for more details

hope this helps

[tobias_klett]

Hi,

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

Hope this helps
Tobias

[ngulliver]

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

[SunilChauhan]

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

here blank will be assign to other id than matching

see applymap in help for more details

hope this helps