Skip to Content
avatar image
Former Member

PI mapping issue

Hi ,

my mapping source and target field:

Source

E1KNB1M-ZSABE or E1KNVKM-ANRED + E1KNVKM-NAMEV + E1KNVKM-NAME1

Target : Contact

i am not able to make mapping logic.it throws exception

Please note:Contact information u2013 should be truncated to 30 characters

if using E1KNVKM and information is too long.

Please confirm in which order i use functions.

regards

Mohit

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Feb 10, 2011 at 11:29 AM
    Please note:Contact information u2013 should be truncated to 30 characters

    use substring function (0,29)

    Add comment
    10|10000 characters needed characters exceeded

    • >>> we need to selct output from fist field OR concatenating last 3 field

      If the above is the condition for the mapping, do the following

      check whether values exist in first field if so, pass the first 30 characters of the first field value to target

      use exist function and if that is true use substring(0,29) and map to the target.

      or

      check whether values exist in the three fields ... and concat all the three fields

      Use concat function for three fields followed by substring(0,29) and map it to target field.

  • avatar image
    Former Member
    Feb 10, 2011 at 02:30 PM

    So you want to map either of the values to your target.

    I mean either E1KNB1M-ZSABE or E1KNVKM-ANRED + E1KNVKM-NAMEV + E1KNVKM-NAME1

    You also mentioned that the length should not exceed 30 characters. So you can do your mapping lke this...

    IF E1KNVKM Not empty then substring (0, 29) else map E1KNVKM-ANRED + E1KNVKM-NAMEV + E1KNVKM-NAME1 to target.

    So this means you have to use "IfElse" function along with "equalS", "NOT", "Constant" and "Substring" function. I hope you can arrange these function as per your need.

    Add comment
    10|10000 characters needed characters exceeded