Skip to Content
avatar image
Former Member

Value Mapping Question

Based on the source filename I need to determine Customer and distribution channel value using value mapping:

Source FileName:
FileName1
FileName2


Target CustomerValue:
300
300

Target Distribution Channel:
ABC
XYZ

I am unable to achieve the above using value mapping

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Mar 04, 2014 at 03:34 PM

    Hi Vicky,

    in cases like that I make a valuemapping putting the two target values together in the valuemapping table. Then splitting the value into the two field I need. So

    FileName1 = 300ABC

    FileName2 = 300XYZ

    Jenny

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Amit Srivastava

      Yes. I am going with the approach mentioned by Jenny and Ram. I don't think the scenario i mentioned can be handled any other way. I would consider this as PI limitation.

      Thanks everyone for your responses.

  • Mar 04, 2014 at 05:57 PM

    Hi Vicky,

    Any specific reason for using value mapping.

    If you are receiving filename in field, then you can also use either if else or  fix value funtion.

    Regards

    Jitender


    asd.JPG (32.2 kB)
    Add comment
    10|10000 characters needed characters exceeded