creating a nested loop in XSLT

Question

I have a list of currency codes that I need to use to create currency pairs. Below is a (simplified) example

<?xml version="1.0" encoding="UTF-8"?>
 <CurrencyLists>
  <Currency>USD</Currency>
  <Currency>BRL</Currency>
  <Currency>EUR</Currency>
  <Currency>GBP</Currency>
 </CurrencyLists>

I'm trying to match each currency to the others to create a pair (cartesian product) like this USDBRL, USDEUR, USDGBP, BRLUSD, BRLEUR, BRLGBP, EURUSD, EURBRL, EURGBP (you get the idea)

I can loop in xslt and get each value but I'm not sure how to get the values a second time here is my sample xslt code

<xsl:template match="/">

    <CurrencyPairs>
     <Total>
         <xsl:value-of select="count(CurrencyLists/Currency)"></xsl:value-of>
     </Total>
    <xsl:for-each select="CurrencyLists/Currency">

    <!--<CurrencyPair><xsl:value-of select="."/></CurrencyPair>-->
        <xsl:variable name="first" select="."/>
        <first><xsl:value-of select="$first"/></first>

       <!-- nested loop / cartesian here -->                


    </xsl:for-each>

    </CurrencyPairs>
</xsl:template>

if I add a second for-each in the middle, I do not get any output. I searched here but didn't see anything that was relevant. I'm trying to make something that allows for more currency codes to be added (like JPY, CHF, THB) without having to create the pairs/cartesian product by hand (which is what I'm doing now)

thanks!

JLRishe · Accepted Answer · 2014-12-04 18:18:36Z

1

You can do so fairly simply, like this:

  <xsl:template match="/">
    <CurrencyPairs>
      <xsl:variable name="allCurrencies" select="CurrencyLists/Currency" />

      <Total>
        <xsl:value-of select="count($allCurrencies)"></xsl:value-of>
      </Total>

      <xsl:for-each select="$allCurrencies">
        <xsl:variable name="first" select="."/>

        <xsl:for-each select="$allCurrencies[. != $first]">
          <CurrencyPair>
            <First>
              <xsl:value-of select="$first" />
            </First>
            <Second>
              <xsl:value-of select="." />
            </Second>
          </CurrencyPair>
        </xsl:for-each>        
      </xsl:for-each>
    </CurrencyPairs>
  </xsl:template>

answered Dec 4, 2014 at 18:18

JLRishe

102k19 gold badges138 silver badges171 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jay Over a year ago

perfect! that works. Thank you very much. I'm not sure what I was doing that it wasn't visible. I have the nested loop working though

Martin Honnen · Accepted Answer · 2014-12-04 18:06:33Z

0

Inside the for-each you can certainly have another one with an absolute path <xsl:for-each select="/CurrencyLists/Currency"> or with a relative to the one of the outer for-each, e.g. <xsl:for-each select="../Currency">.

answered Dec 4, 2014 at 18:06

Martin Honnen

169k6 gold badges100 silver badges122 bronze badges

Collectives™ on Stack Overflow

creating a nested loop in XSLT

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related