applymap?

[Anonymous]

Hi

how it works

applymap('item',product,'100%')

what is 100% here  i know that not matching values will go there  is in't or anything is there?

[its_anandrjs · Accepted solution]

Hi,

Yes right when no value match 100% is fill there.

Regards

Anand

[Anonymous]

This 3rd parameter can be anything whatever you want to insert dummy value if condition is not matching

It works just like VLOOKUP in Excel but the lookup table must only contain 2 columns

see this also

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

[maleksafa]

applymap('mapname', expr [ , defaultexpr ] )

the third value in your case '100%' which is optional is the default value if the applymap did not match.