Mapping Issue

[former_member10771]

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.

[former_member226514]

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

[former_member10771]

Hi All,

Thanks for the response.

I tried using sort also tried changing the contexts somehow I am not getting the desired result.

In the display queue it is showing correctly but when I do a actual test in mapping it again gives the same old result.

[Harish]

Hi Amit.

If you are applying the Sort at the node level then you need to apply the sort by value in fields of that node. Please share the details of your mapping with structure to give more inputs.

regards,

Harish

[rajasekhar_reddy14]

Share your mapping screen short .

[Former Member]

Hello,

Sort function should satisfy ur requirement, may be u can paste ur mapping screen shot here - wanted to look how u r doing node and field level mapping.

Thanks

Amit Srivastava

[iaki_vila]

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.

[Former Member]

Hello Amit,

Please make use of Sort Function after RemoveContext.

I think you will get the output as you desire.

Thanks,

Kalyan

[Former Member]

Hello,

Use this:

Vendor - > remove context ->sort -> split by value (value change ) -> collapse context -> row.

Thanks

Amit Srivastava