Skip to Content
avatar image
Former Member

Multiple conditions in one

Hi,

I have to put constants values L1 or L2 or L3 into a single target field but with constants it is not working.

Is their any other way of doing it?

Regards,

Aniruddha

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 05, 2011 at 01:51 PM

    Since, it is the target only which needs to be get feed, no source filed is their.

    Regards,

    Aniruddha

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello,

      You can concatenate the constant values and map the result into the target field. This don't require UDF to be created.

      Regards,

      Anand Patil

  • avatar image
    Former Member
    Jan 05, 2011 at 12:02 PM

    HI ,

    Anirudha , you can Use XI functions Here ... Boolean Functions .. Like If else if . etc.

    Or

    You can Write UDF also

    Give Ur exact requirement , I can make u a UDF or tell ya Graphical set of fuction to achive such requiremnet.

    Regards

    Prabhat Sharma.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 05, 2011 at 11:57 AM

    Hi,

    if you want to pass the constant values to the target field based on the condition then you can..using the Boolean OR Function.

    or mention your exact requirement ...when the value of L1 or L2 or L3 to be passed to the target field

    HTH

    Rajesh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 05, 2011 at 11:58 AM

    >

    > Hi,

    > I have to put constants values L1 or L2 or L3 into a single target field but with constants it is not working.

    > Is their any other way of doing it?

    >

    >

    > Regards,

    > Aniruddha

    Hi,

    On what conditions you need to send these constants to target ??

    Regards

    Rahul grover

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 05, 2011 at 12:06 PM

    Thanks a lot everyone, my exact requirement is to have L1 OR L2 OR L3 to be feed in the target filed as it is not coming from sender.

    Is there are graphical mappings for this re.

    Regards,

    Aniruddha

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      here Fix value Function will not work we use it ,when we want to Use Some fix Value in Place of Any Particular value

      Like .

      Whenever Source Gets Key Value it will return your given value

      key value

      Prabhat P

      So whenever source will come up with Prabhat it will rerurn P.

      Regards

      Prabhat

  • avatar image
    Former Member
    Jan 05, 2011 at 12:58 PM

    Hi,

    The simplest way of doing it is using fix value function.

    Regards,

    Sainath Chutke

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 05, 2011 at 01:49 PM

    Hi Prabhat,

    Thanks a lot for your answers. I was just thinking can we use any graphical method to do this. As UDF usage is not allowed always in our scenarios here.

    Regards,

    Aniruddha

    Add comment
    10|10000 characters needed characters exceeded