on 03-04-2014 3:18 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vicky,
You can split the values in mapping using the method mentioned by Jenny
Filename1 300|ABC
Filename2 300|XYZ
or use two value mappings, one for Customer and other for Distribution channel to determine output values based on File name.
Value map1
Filename1 300
Filename2 300
Value map2
Filename1 ABC
Filename2 XYZ
Refer below link on how to create value maps:
XI/PI: Value Mapping Using Graphical Editor
Regards,
Pranav
Ram,
SAP PI does not let me create two value mapping groups which contain the same values for source scehma and agency.
TO my knowledge this is not possible:
Value map1
Filename1 300
Filename2 300
Value map2
Filename1 ABC
Filename2 XYZ
this will throw an error saying that Filename1 is already being used in the value map1.
Amit,
Thanks for your inputs. But this is not the scenario I am talking about. I am aware that N (FileName):1(CustomerValue) mapping can be done. Lets say N is 2 here with value FILENAME1 and FILENAME2.
so I will have one value mapping group for the above.
But now lets says I have a requirement to cerate a new value mapping FILENAME1 (only) to DISTRIBUTION CHANNEL1 and another value mapping FILENAME2 (only) to DISTRIBUTION CHANNEL2.
When I try to create the above I get an error saying FILENAME1 is already being used in Value mapping group 1.
Hello,
>>When I try to create the above I get an error saying FILENAME1 is already being used in Value mapping group 1.
As of now, i don't have a system to test it, but Ram's reply confirms that it's possible.
BTW, why don't u just club CustomerValue + Distribution channel name at VM and then extract values while doing mapping?
Thanks
Amit Srivastava
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.