Value Mapping requirement

[#1]

Hi Experts, I have a requiremnet to fail the mapping if value mapping lookup (standard valuemapping) fails...

For example

vendor --111 --valuemaplookup to aaa ---target =aaa

if vendor 222 does not have value defined in value map table it has to fail the mapping...I am not sure its not working its outputting 222 in the target , any idea whats the cause.

Regards

Ravikiran

[Former Member]

create a UDF for this lookup and for not required values, throw exception using throws statement.

[Former Member]

Hi Ravikiran,

@RAJEEV GUPTA: UDF is not required here, standard configuration of Value Mapping function can be used.

The solution is: when you double-click the Value Mapping function, a configuration popup appears. You can choose the expected behavior when the lookup fails: Use Key (which is the default and apparently is used in your case), Use Default Value and Throw Exception. You should use the last one in your case. See below:

Hope this helps,
Greg

[Former Member]

Hi , thanks for the update , initially that was i thought , but I donot have "throw exception " option might due to patch level of XI ..using 7.0 ...