Grouping of messages

[Former Member]

Hello All,

Here I have a requirement of flat file to proxy.

Input Flat file contains multiple records. I have to group messages based 2 Input fields(Location and ZIP).

If the Input file has 4 records with Location and ZIP same for 2 records then I have to produce 3 messages to SAP.

Can any one tell me the approach on this

Thanks,

Regards,

Moorthy

[PriyankaAnagani · Accepted solution]

Hi Moorthy,

Try with this graphical mapping....

First concatinate the 2 input fields location and ZIP with an empty string.

result of concatination>removecontext>sort>splitByValuechange>collapseContext-->TargetProxyMsg

Regards,

Priyanka

[Former Member]

u can try something like this in ur mapping:

Location---removeContext--
 --------- --------Concat----sort---spliby value(value change)---collapse context---Target
Zip--------removecontext--

[baskar_gopalakrishnan2]

Yes first you need to do remove context for both location and zip, followed by concat and then sort and then splitbyvalue(change) and finally collapsecontext