Re: Newbie needs XSL help, 1-to-many xform, multi-valu

My problem is, i do not know how to create multiple elements from a single element with several multi-value child elements.

The order of the child nodes has meaning that is managed by the Notes application, so that the set of multi-value data items has the meaning of one two-dimensional array of data.

If my application puts three people and their cities into one Notes document, Domino gives me XML much like this (simplified of course):
...
I need to turn that one "MyRecord" element into multiple "ATransaction" elements (three of them, in this case). Each of them has certain data from "MyRecord", along with only one value from each of the multi-child elements "MyNames" and "MyCities".
...

T:\ftemp>type hulk.xml
 <MyRecord>
   <BranchID> 12345 </BranchID>
   <RecordDate> November 3, 2009 </RecordDate>
   <MyNames>
      <Name> John Doe </Name>
      <Name> Rachel Roe </Name>
      <Name> Biff Jones </Name>
   </MyNames>
   <MyCities>
      <City> Kalamazoo </City>
      <City> Katmandu </City>
      <City> Timbuktu </City>
   </MyCities>
 </MyRecord>
T:\ftemp>xslt hulk.xml hulk.xsl
<?xml version="1.0" encoding="utf-8"?>
<Transactions>
   <ATransaction>
      <Branch> 12345 </Branch>
      <When> November 3, 2009 </When>
      <Who> John Doe </Who>
      <Where> Kalamazoo </Where>
   </ATransaction>
   <ATransaction>
      <Branch> 12345 </Branch>
      <When> November 3, 2009 </When>
      <Who> Rachel Roe </Who>
      <Where> Katmandu </Where>
   </ATransaction>
   <ATransaction>
      <Branch> 12345 </Branch>
      <When> November 3, 2009 </When>
      <Who> Biff Jones </Who>
      <Where> Timbuktu </Where>
   </ATransaction>
</Transactions>
T:\ftemp>type hulk.xsl
<?xml version="1.0" encoding="US-ASCII"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
                version="1.0">

<xsl:template match="MyRecord">
  <Transactions>
    <xsl:variable name="this" select="."/>
    <xsl:for-each select="MyNames/Name">
      <xsl:variable name="pos" select="position()"/>
      <xsl:for-each select="$this">
        <ATransaction>
          <Branch><xsl:apply-templates select="BranchID/node()"/></Branch>
          <When><xsl:apply-templates select="RecordDate/node()"/></When>
          <Who>
            <xsl:apply-templates select="MyNames/Name[$pos]/node()"/>
          </Who>
          <Where>
            <xsl:apply-templates select="MyCities/City[$pos]/node()"/>
          </Where>
        </ATransaction>
      </xsl:for-each>
    </xsl:for-each>
  </Transactions>
</xsl:template>

</xsl:stylesheet>
T:\ftemp>

--
Contact us for world-wide XML consulting & instructor-led training
Crane Softwrights Ltd.          http://www.CraneSoftwrights.com/s/
G. Ken Holman                 mailto:gkholman@xxxxxxxxxxxxxxxxxxxx
Legal business disclaimers:  http://www.CraneSoftwrights.com/legal