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

[Former Member]

Hi,

When you check the Fix Values settings, what is your setting for Behaviour if Lookup Fails? If you are using Throw Exception, try changing it to one of the other options and see what happens.

Regards,

Greg