Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

applymap?

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?

1 Solution

Accepted Solutions
its_anandrjs

Hi,

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

Regards

Anand

View solution in original post

3 Replies
its_anandrjs

Hi,

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

Regards

Anand

Anonymous
Not applicable
Author

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

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


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