on 11-06-2015 3:42 AM
Source: two delivery line items
<Delivery>
<AddressLine1>1237 South Main Street
<AddressLine1>Apt 4E
</Delivery>
<Delivery>
<AddressLine1>1237 West Main Street
<AddressLine1>Apt 5G
</Delivery>
Here <AddressLine> is 1 to unbounded
Target: Two Ship to Addresses
<Address>
<Street>1237 South Main Street
<Strret2>Apt 4E
</Address>
<Address>
<Street>1237 West Main Street
<Strret2>Apt 5G
</Address>
I did the mapping as below. It works fine for the single delivery to single ship to address but not working for multiple deliveries to Multiple ship to addresses. Can anyone please help me how can I solve this?
Thanks
Hello SAP PI,
Why your using count function.
You can do direct mapping right?which will create if one delivery then one address else 2 means 2.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
change the mapping as
AddressLine1 -> collaps cotext --> splitbyvalue -> street
regards,
Harish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Street2 mapping having two option
1) If you are sure that first field always start with numberr and second always start with alphabat then use the sort function and sort the second field in first position.
Then apply the same logic as street field.
2) Write the java code and suppress the first value of queue.
regards,
Harish
User | Count |
---|---|
80 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.