Somewhat new to XSLT.

I have an xml file: Note two Workorder_Equipment elements
<Workorder_Equipment>
    <Workorder_ID>436</Workorder_ID>
    <Description>Bunn - B38 - FMD-3*</Description>
</Workorder_Equipment>
<Workorder_Equipment>
    <Workorder_ID>436</Workorder_ID>
    <Description>Bunn - Airpot - An Airpot</Description>
</Workorder_Equipment>

I want to append the description values together to look like:
 <COLUMN name="Description">
<VAL>Bunn - B38 - FMD-3* &lt;BR&gt; Bunn - Airpot - An Airpot</VAL>
 </COLUMN>

When I use concat or the following in the XSLT
<xsl:template match="Data/Workorder_Equipment">
  <COLUMN name=""order_line_problem_desc"">
  <VAL>
   <xsl:value-of select="Description"/>
   <xsl:text> &lt;BR&gt; </xsl:text>
   <xsl:value-of select="Description"/>
  </VAL>
 </COLUMN>
 <COLUMN name="order_line_po_id">
  <VAL>
    <xsl:value-of select="Workorder_ID"/>
    </VAL>
 </COLUMN>
             <xsl:apply-templates/>
   </xsl:template>

I get:

<COLUMN name="order_line_problem_desc">
<VAL>Bunn - B38 - FMD-3* &lt;BR&gt; Bunn - B38 - FMD-3*</VAL>
</COLUMN>

It concats the same value. Is there a way to get the two different values concatenated or appended to each other? Also I from the xml file on out put I get two Wororder_ID values and I only need one.
i.e. <COLUMN name="order_line_po_id"><VAL>436</VAL>
         </COLUMN>
     <COLUMN name="order_line_po_id"><VAL>436</VAL>
         </COLUMN>

The resulting output XML file is used for import into a SQL server.
Thanks

Looks like you want to group workorders having the same ID. Grouping in XSLT 1.0 is a bit of a black art: see http://www.jenitennison.com/xslt/grouping. In XSLT 2.0 it's much easier, there's an xsl:for-each-group instruction.

You're showing the template that's activated to process a single workorder at a time. Clearly any grouping or concatenation has to happen at the next level up, when you process a collection of workorders. You haven't shown what the next level up in your XML looks like.

You can concatenate elements using concat() or using a sequence of xsl:value-of elements as you tried. But clearly if you select the same Description element twice then it's going to select the same one each time.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

Thanks for your reply. for space reasons i did not post the next level up but here it is:

<Data>
<Workorder_Equipment>
    <Workorder_ID>436</Workorder_ID>
    <Description>Bunn - B38 - FMD-3*</Description>
</Workorder_Equipment>
<Workorder_Equipment>
    <Workorder_ID>436</Workorder_ID>
    <Description>Bunn - Airpot - An Airpot</Description>
</Workorder_Equipment>
</Data>

If you just want to solve the concatenation problem and ignore the grouping for now, you can do

<xsl:template match="Data">
  <xsl:for-each select="Workorder_Equipment">
     <xsl:value-of select="Description"/>
     <br/>
  </xsl:for-each>
</xsl:template>

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

I have finished this stylesheet and i want to thank you Michael Kay for the great help. I know this was a simple one but its a step in the right direction for me. I would like to purchase your book.

Thanks