Merge XML within a file

blacksab

Hello, I have an xml-file like this:

Expand|Select|Wrap|Line Numbers

  
<ROOT>

  <ORDER_LINES>

    <DATA>

      <LINE_NO>1</LINE_NO>

      <MISC_INFO/>

    </DATA>

    <DATA>

      <LINE_NO>2</LINE_NO>

      <MISC_INFO/>

    </DATA>

  </ORDER_LINES>
 
  <SORT>

    <LINE_NO sort_no="2">1</LINE_NO>

    <LINE_NO sort_no="1">2</LINE_NO>

  </SORT>

</ROOT>

In XSLT 1.0, how would I go about producing this output:

Expand|Select|Wrap|Line Numbers

 
  <ORDER_LINES>

    <DATA>

      <LINE_NO sort_no="1">2</LINE_NO>

      <MISC_INFO/>

    </DATA>

    <DATA>

      <LINE_NO sort_no="2">1</LINE_NO>

      <MISC_INFO/>

    </DATA>

  </ORDER_LINES>

I hva tried differrent solutions for this over the past couple of days. But have failed in producing the desired output every time. The problem lies in merging the two nodes. (The tag xsl:sort helps me sort accordingly though).

Any help would be greatly appreciated.....

Dormilich

I wouldn't try to merge the nodes, replace one with its counterpart.

Expand|Select|Wrap|Line Numbers

 <xsl:template match="LINE_NO[not(ancestor-or-self::SORT)]">

  <xsl:copy-of select="//LINE_NO[@sort_no = current()]"/>

</xsl:template>

regards

jkmyoung

Suggest sort on apply-templates at the data element. It's hard to tell without seeing the rest of your code.

Expand|Select|Wrap|Line Numbers

 
<xsl:template match="ORDER_LINES">

  <xsl:copy>

    <xsl:apply-templates select="DATA">

      <xsl:sort select="//SORT/LINE_NO[.=current()/LINE_NO]/@sort_no"/>

   </xsl:apply-templates>

  </xsl:copy>

</xsl:template>

<xsl:template match="LINE_NO">

   <xsl:copy-of select"//SORT/LINE_NO[.=current()]"/>

</xsl:template>

<xsl:template match="*"> <!-- default copy template -->

  <xsl:copy>

    <xsl:copy-of select="@*"/>

    <xsl:apply-templates/>

  </xsl:copy>

</xsl:template>

blacksab

Wow, thank you all for quick replies. Problem is solved! Adopted both suggestions into my solution and it finally works.

Dormilich

I'm pleased to hear that we could help.

Merge XML within a file

re: Merge XML within a file

re: Merge XML within a file

re: Merge XML within a file

re: Merge XML within a file

Similar XML bytes

/bytes/development

/bytes/it

/bytes/about