on 01-03-2014 8:35 AM
Hi ,
I have done a mapping where in I am mapping to a target node and it must create separate messages for change in vendor.
I have mapped in this way
Vendor - > remove context -> split by value (value change ) -> collapse context -> row.
When I test it with say 123 123 and 125 as data I get the result perfectly. Where in 123 gets clubbed together as a single message in one parent node and 125 into another node.
However if I change the data to say 123 123 125 and 123 then for the last 123 it creates a separate node . But I want that all these 3 to come under one node . basically the ones that are similar need to be clubbed in one parent node and the remaining in another.
Hi Amit,
Please do a sort after remove context before split by value
Please note you need to use SORT for the vendor field and sortByKey for other fields.
More on standard functions...
http://scn.sap.com/thread/927146
Regards,
Karthik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Amit,
Try to use the standard function Sort before the splitByValue. Check Stefan Grube's blog http://scn.sap.com/people/stefan.grube/blog/2005/12/29/new-functions-in-the-graphical-mapping-tool-x...
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Amit,
Please make use of Sort Function after RemoveContext.
I think you will get the output as you desire.
Thanks,
Kalyan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Use this:
Vendor - > remove context ->sort -> split by value (value change ) -> collapse context -> row.
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 |
---|---|
96 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
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.