Issue with Fixed value mapping

[former_member218849]

Dear Experts,

I am stuck in a mapping situation as explained below and need  your help for resolution.

Mapping in contention  is as shown below :

As per this mapping the Substring should throw 3 character word and  in fix value mapping it is getting displayed correctly. The fix value mapping is as shown below:

queue result of Substring function in mapping :

Queue Result for Fix Value mapping :

Till this point every thing looks fine but when I clicked on the Queue of the Target field it throws out the error as:

Here it clearly shows that output of the key in fix value mapping is null, which contradicts the result of  fix value mapping queue.

Please let me know if any one else has faced this  issue before  or if you have any idea for the resolution of this issue.

Thanks and Regards,

Sudhir Kumar

[santosh_k3]

Hi Sudhir,

Hope i have understand the requirement correctly/

As shown above in the screen shots of Fixed value mapping

there are only three keys

1) SA_

2) FA_

3) IT_

but the output of the sub string function resulting PR_

which is not present in the Fixed value mapping as a key

try to maintain the key value pair in fixed value mapping for

key = PR_

value = Procurement

so when ever the sub string results the output as PR_ then Procurement will be passed to the Target element.

Thanks

Sai