Skip to Content
author's profile photo Former Member
Former Member

Mapping help or UDF

Hello Friends,

I need some help in mapping through regular or UDF.

Requirment is I have target field CORD_CODE,

This needs to ge the value based on the segment values of EIEDT44-VSTEL

If VSTEL = CO10 then 1055

If VSTEL = CO11 then 1054

If VSTEL = CO13 then 1057

If VSTEL = CO12 then 1056

Like this.

Can we create UDF for the same or anyt other alternative?

<removed by moderator>

Regards

Ramesh

Edited by: Mike Pokraka on Jul 24, 2008 1:46 PM

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 22, 2008 at 08:34 AM

    Hi ramesh,

    you can handle it with IF Then Else conditions.....

    If VSTEL = CO10 then 1055

    If VSTEL = CO11 then 1054

    If VSTEL = CO13 then 1057

    If VSTEL = CO12 then 1056

    If VSTEL = CO10 then 1055 else drag and drop another if-then-else and if VSTEL = CO11 then 1054 else drag and drop another if-then-else and if VSTEL = CO13 then 1057 and drop another if-then-else and if VSTEL = CO12 then 1056 .....

    no need to go for UDF....

    Thanks,

    Madhu

    Edited by: Madhu sudhan Reddy on Jul 22, 2008 10:34 AM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 22, 2008 at 08:34 AM

    Hi,

    you could use standard function FixValues (under Conversions).

    Just put it between source and target and double click it on it.

    A table will open where you could enter your value pairs.

    Regards

    Patrick

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 22, 2008 at 08:34 AM

    hi

    use fix values option in mapping.

    take VSTEL as source and give fix value function in between source and target

    in this fix value give values like

    CO10 1055

    CO11 1054

    CO13 1057

    CO12 1056

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Just to elaborate:

      If your source come like this

      a

      a

      a

      with no context change then your target field would also have to be

      t

      t

      t

      if you have an element above the t like this

      Segment

      t

      Segment

      t

      Segment

      t

      then you will get your error.

      So what you need to do it either split by value or change the context of your source node which you can do by right clicking on the source node in your graphical mapping

      Edited by: Alex on Jul 22, 2008 11:23 AM

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.