Skip to Content
avatar image
Former Member

Mapping issue

Hi Experts,

I have to map a field A to a field B. The req is that whatever +ive or -ive value coming from that field suppose 2 then map filed B with 2, also if -2 vlaue is coming from field A then also map with field B as 2 only.

I have tried doing that by standard functions constants and greater than but it is returning Boolean value True or False.

How can I get the value??

Please help.

Regards,

Aniruddha

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Dec 29, 2010 at 01:35 PM
    FieldA --> 
              --> startsWith --> ifWithElse (FieldA --> Else) --> FieldB
    Constant(-)-->

    FieldA --> replaceString ➖ --> Then

    Regards,

    Abhishek.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 29, 2010 at 01:17 PM

    >

    > Hi Experts,

    > I have to map a field A to a field B. The req is that whatever +ive or -ive value coming from that field suppose 2 then map filed B with 2, also if -2 vlaue is coming from field A then also map with field B as 2 only.

    >

    >

    > I have tried doing that by standard functions constants and greater than but it is returning Boolean value True or False.

    >

    > How can I get the value??

    if

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 29, 2010 at 01:23 PM

    Hi Aniruddha,

    Use Ifwithelse function and map accordingly.

    Thanks,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 29, 2010 at 02:22 PM

    Thanks everyone for your replies it is working ok now.

    Regards,

    Aniruddha

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 29, 2010 at 02:25 PM

    Use arithmetic function 'abs' for this!

    -

    Srikanth Srinivasan

    Add comment
    10|10000 characters needed characters exceeded