MQSeries.net :: View topic

mguerr5 · Posted: Wed Feb 23, 2005 7:50 am Post subject: Aggregate fields within a message

Hi all -

We have a flow developed that processes a rather large quantity of input ascii messages and outputs in XML based on a respective parent-child heirarchy. This works fine and dandy. We now have been tasked with integrating the output into a new system that was not in the picture 2 months ago. The input/output messages are sales transactions. The issue: We do not aggregate our sales at the point of sale. If I buy 2 widgets and one wadget, the transaction(receipt) will show three different items as opposed to 2 items, with the quantity of widgets being 2. The new system that we will be feeding will bomb out if we send it a duplicate. Any ideas on how we can aggregate data within respective messages? I need to drop the 'duplicate' and increment the quantity field. I am hoping that there is a node out there that may give me some of what I need? I c an do it via custome esql, but would like to avoid if for fear that things may take a significant performance hit based on our volumes. I looked into the aggregate node and that appears to handle aggregation on a larger scale (entire messages). Thanks in advance for any assistance.