Merging XML records into one

Posted by BhanuPratap Tarigopula on Stack Overflow See other posts from Stack Overflow or by BhanuPratap Tarigopula
Published on 2013-10-24T18:48:26Z Indexed on 2013/11/04 9:55 UTC
Read the original article Hit count: 273

Filed under:

Xml

|

xslt

I am new to XSLT. I have requirement of merging and adding.

XML:

<OrderDetails>
  <OrderDetail action="add">
    <OrderedUnits>18</OrderedUnits>
    <Date>2013-09-30T00:00:00</Date>
    <LocationCode>3202</LocationCode>
    <PONumber>022548295755</PONumber>
  </OrderDetail>
  <OrderDetail action="add">
    <OrderedUnits>12</OrderedUnits>
    <Date>2013-09-30T00:00:00</Date>
    <LocationCode>3202</LocationCode>
    <PONumber>022548295755</PONumber>
  </OrderDetail>
  <IOrderDetail action="add">
    <OrderedUnits>18</OrderedUnits>
    <Date>2013-09-30T00:00:00</Date>
    <LocationCode>3202</LocationCode>
    <PONumber>022548295762</PONumber>
  </OrderDetail>
<OrderDetails>

If the LocationCode, Date, and PONumber fields match, I need to add the OrderedUnits and make it only one entry.

Expected output XML:

<OrderDetails>
  <OrderDetail action="add">
    <OrderedUnits>30</OrderedUnits>
    <Date>2013-09-30T00:00:00</Date>
    <LocationCode>3202</LocationCode>
    <PONumber>022548295755</PONumber>
  </OrderDetail>
  <IOrderDetail action="add">
    <OrderedUnits>18</OrderedUnits>
    <Date>2013-09-30T00:00:00</Date>
    <LocationCode>3202</LocationCode>
    <PONumber>022548295762</PONumber>
  </OrderDetail>
<OrderDetails>

How can I write this XSLT?

© Stack Overflow or respective owner

Related posts about Xml

Store XML,update record in XML,retrive a specific record in XML stored on BB device

as seen on Stack Overflow - Search for 'Stack Overflow'
I am writing a blackberry application where i want to store the data returned by a web service in my BB device.Earlier i was going to use SQLite for storing the data in mobile but as i googled and also did programming using SQLite and found that some BB devices dont support SQLite library and fail… >>> More
gwt+xml- can i read through incomplete XML using the GWT XML Parser

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a requirement where a user is typing in XML in a text area, and I want to show the various nodes in a tree...But as the user is typing in the xml, it wont be a complete xml (since he is still typing in the XML)... How do I read an incomplete XML and correctly generate the tree? I understand… >>> More
perl xml parser get xml content within xml

as seen on Stack Overflow - Search for 'Stack Overflow'
How can I use XMLParser to get the item-@url, item-@replace and item-"value inside" for the content as a string of the node where item-@cone="one"? <cstep> <item cone="one" url="http://google.com/{ccc}/cthree" replace="{ccc}"> <itemsub conesub="conesub"> … >>> More
Reading php generated XML in flash?

as seen on Stack Overflow - Search for 'Stack Overflow'
Here is part 1 of our problem (Loading a dynamically generated XML file as PHP in Flash). Now we were able to get Flash to read the XML file, but we can only see the Flash render correctly when tested(test movie) from the actual Flash program. However, when we upload our files online to preview the… >>> More
Announcing RSS feeds of Microsoft All-In-One Code Framework code samples

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Today, we are not only announcing Sample Browser v2 CTP, but we are also excited to announce the availability of RSS feeds of All-In-One Code Framework code samples. By using these feeds, you can easily track and download the new code samples. English RSS feeds All code samples: http://support… >>> More

Related posts about xslt

Why do XSLT editors insert tab or space characters into XSLT to format it?

as seen on Programmers - Search for 'Programmers'
All XSLT editors I've tried till now add tab or space characters to the XSLT to indent it for formatting. This is done even in places within the XSLT where these characters are significant to the XSLT processor. XSLT modified for formatting in this way can produce output very different to that of… >>> More
How to replace text defined in a given tag or element using xslt, xslt string replace

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All, Please help me with this xslt transformation. Source Xml <xml> <test>This is a <bold>sample</bold> description. Please help me with a sample</text> </xml> Expected Output: This is a sample description. Please help me with a sample I just need to make… >>> More
C# and XSLT (using document() function in XSLT generates error)

as seen on Stack Overflow - Search for 'Stack Overflow'
I'd like to use embedded resources in my XSLT file, but while invoking 'document(...)' C# complains that "Error during loading document ..." I'd like to use defined resources in XSLT file and get them by this: "document('')//my:resources/"... How can i do that?? ex xsl: <?xml version="1.0"… >>> More
Turning XSLT into a simple HTML snippet.

as seen on Stack Overflow - Search for 'Stack Overflow'
http://drp.ly/yeAex <?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:template match="/data/tour/entry"> <img src="{filename}"/> <h2>{heading}</h2> {description} </xsl:template> </xsl:stylesheet> Here… >>> More
JQuery > XSLT Plugin > Component returned failure code: 0x80600011 [nsIXSLTProcessorObsolete.transfo

as seen on Stack Overflow - Search for 'Stack Overflow'
So, I'm using the XSLT plugin for JQuery, and here's my code: function AddPlotcardEventHandlers(){ // some code } function reportError(exception){ alert(exception.constructor.name + " Exception: " + ((exception.name) ? exception.name : "[unknown name]") + " - " + exception.message); } function… >>> More