Skip to Content
avatar image
Former Member

Value mapping : target value need to be blank

Hi,

I have a requirement like below (just example).

Source Target

A Z

B Y

C X

N BLANK or ""

When I did this using value mapping it works fine for all values except for source value 'N'.

When the source is N then the target should have value space or blank. Is this not supported by value mapping?

For value N, do i have to explicitly check 'if value N then make it blank'?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jun 11, 2010 at 07:34 PM

    I am not sure if value mapping supports blank value as result or not. But if you have checked your result in MONI then you won't see the blank value, try to see the source code of Payload data (right click and select view source code). If you see the blank value then it means value mapping works else you have to explicitly check 'if value N then make it blank'.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Prasand,

      can you try to give any value(say ABC) for N in the value mapping and in the filed mapping where you pass the value of n to targer structure ,try overwriting/replacing (use replace value or a UDF) ABC to a Blank space.I think this may help .

      Regards,

      Srinivas