Need help with this one.

I have the following XML code (IMS Enterprise standard):

<person>
    <sourcedid>
      <sourcedidtype>"Old"</sourcedidtype>
      <source>NO-FS</source>
      <id>123</id>
    </sourcedid>
    <sourcedid>
      <sourcedidtype>"New"</sourcedidtype>
      <source>NO-FS</source>
      <id>789</id>
    </sourcedid>
    <userid>dunn</userid>
</person>

How can I make my XSLT mapper file select the sourcedid/id where sourcedidtype = "New"? By using a xsl:if or a xsl:when the ordinary way I only retrieve the old sourcedid/id since this one is listed first.

[u]My XSLT so far...</u>

<xsl:template match="person">
<ims_person>
   <sourcedid_id>
      ???
   </sourcedid_id>
   <sourcedid_source>
      <xsl:value-of select="sourcedid/source" />
   </sourcedid_source>
   <userid_id>
      <xsl:value-of select="userid" />
   </userid_id>
</ims_person>
</xsl:template>

Please help me if you have any good suggestions!

PS. Not sure if I need to split up the <sourcedid_id> tag into <sourcedid> and <id> in this case...?

>How can I make my XSLT mapper file select the sourcedid/id where sourcedidtype = "New"


<xsl:variable name="new">"New"</xsl:variable>
<xsl:value-of select="sourcedid[sourcedidtype=$new]/source" />

(the variable is the easiest way of dealing with the fact that the value is in quotes).

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

Thank you Michael!

That code worked perfectly!

Remember me to cheer for England in the next World Cup :o)

Best regards
gnesland
-Norway-

Awww... forgot one thing.

The XML-file will contain both person objects like the example above, but it will also contain object with only a single sourcedid/id tag, and no sourcedid/sourcedidtype tag. The code should therefore be capable to also select the ID when there is no "Old" or "New" sourcedidtype.

The example below illutrates two different objects that may occur in the same file:

<person>
   <sourcedid>
      <source>NO-FS</source>
      <id>111</id>
   </sourcedid>
   <userid>phillip</userid>
</person>
<person>
    <sourcedid>
      <sourcedidtype>"Old"</sourcedidtype>
      <source>NO-FS</source>
      <id>123</id>
    </sourcedid>
    <sourcedid>
      <sourcedidtype>"New"</sourcedidtype>
      <source>NO-FS</source>
      <id>789</id>
    </sourcedid>
    <userid>dunn</userid>
</person>

How can I handle both cases so that I retrieve the single ID when the object contains a single Id, and the New one when the object contains two IDs?

These are very basic questions, and I wonder whether you are really going the right way about learning the language. Have you been reading any XSLT books and studying the examples?

A good way to tackle this would be to have two template rules, one for person elements with a single sourcedid, another for those with two.

<xsl:template match="person[count(sourcedid)=1]">
   <sourcedid_source>
      <xsl:value-of select="sourcedid/source" />
   </sourcedid_source>
</xsl:template>

<xsl:template match="person[count(sourcedid)=2]">
   <sourcedid_source>
      <xsl:variable name="new">"New"</xsl:variable>
      <xsl:value-of select="sourcedid[sourcedidtype=$new]/source" />
   </sourcedid_source>
</xsl:template>

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