Add Missing Elements 1

[Elysium]

To all:

If there's an article on this already, please post the link. Okay, here's what I want to accomplish:

Convert this XML structure:

<employee>
   <empid>123456</empid>
   <firstname>Jon</firstname>
   <lastname>Doe</lastname>
</employee>
<employee>
   <firstname>Harry</firstname>
   <lastname>Carry</lastname>
</employee>

Into this XML structure:

<record>
   <empid>123456</empid>
   <firstname>Jon</firstname>
   <lastname>Doe</lastname>
</record>
<record>
   <empid>Null</empid>
   <firstname>Harry</firstname>
   <lastname>Carry</lastname>
</record>

Take note that the second employee was missing the "empid" element in the first XML structure. However, in the second XML structure, it is presenet with "Null" for the value.

I've been messing around with XSLT, but no success so far. Thanks for any and all help with this.

Randy

 

[MrGrey]

This is the kind of thing you want

<xsl:stylesheet version="1.0" xmlns:xsl="

http://www.w3.org/1999/XSL/Transform">

<xslutput method="xml"/>

<xsl:template match="employees">

<xsl:apply-templates select="employee" />

</xsl:template>

<xsl:template match="employee">

<record>
<empid>
<xsl:choose>
<xsl:when test="empid"><xsl:value-of select="empid" /></xsl:when>
<xsltherwise>Null</xsltherwise>
</xsl:choose>
</empid>
<firstname><xsl:value-of select="firstname" /></firstname>
<lastname><xsl:value-of select="lastname" /></lastname>
</record>

</xsl:template>

</xsl:stylesheet>

 

[Elysium]

Awesome!! Works great! Thank you.

Randy