XSLT Concatenation from different nodes when a string is found

Question

I want to concatenate different nodes from "Time" until there is another data provided in "Sum". Most of the sum nodes are empty. I will like to concatenate the all nodes before the next SUM value to a single reference field.

    <?xml version="1.0"?>
    <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
        <!-- recursive named template -->
        <xsl:template name="hm">
            <xsl:param name="amount"/>
            <xsl:param name="pos"/>
            <xsl:for-each select="../row">
                <xsl:if test="$amount = Sum and $pos = position()"></xsl:if>
                <xsl:choose>
                    <xsl:when test="string-length(Sum) &gt; 0">
                        <xsl:value-of select="Time"/>
                    </xsl:when>
                    <xsl:otherwise>
                        <xsl:value-of select="', '"/>
                        <xsl:value-of select="Time"/>
                    </xsl:otherwise>
                </xsl:choose>
            </xsl:for-each>
        </xsl:template>
                            <Reference>
                                <xsl:call-template name="hm">
                                    <xsl:with-param name="amount" select="Sum"/>
                                    <xsl:with-param name="pos" select="position()"/>
                                </xsl:call-template>
                            </Reference>
                        </Payment>
                    </xsl:if>
                </xsl:for-each>
            </Trailer>
        </xsl:template>
    </xsl:stylesheet>

> > # #

 <Trailer> 
             <Payment>  
              <Reference>Debit,TMU/2023/1059 A ,TMU/2023/1019 A ,TMU/2023/1020 A, Debit,56011846 A 
    </Reference> 
              </Payment> 
              <Payment> 
               <Reference>Debit,TMU/2023/1059 A ,TMU/2023/1019 A ,TMU/2023/1020 A, Debit,56011846 A 
    </Reference> 
               </Payment>
        </Trailer>

> #

    <Trailer> 
    <Payment> 
     <Reference>Debit,TMU/2023/1059 A ,TMU/2023/1019 A ,TMU/2023/1020 A </Reference> 
    </Payment> 
    <Payment> 
     <Reference> Debit,56011846 A </Reference>
    </Payment>
    </Trailer>

**> > #This is the xml input which has the nodes SUM and TIME. Most of the sum nodes are empty. I will like to concatenate the all nodes

before the next SUM value to a single reference field.**

<root>
        <row>
             <Time>Debit</Time>
             <Sum>(874,516.25)</Sum>
       </row>
        <row>
               <Time>TMU/2023/1059 A</Time> 
               <Sum></Sum> 
      </row>
       <row> 
              <Time>TMU/2023/1019 A</Time>
               <Sum></Sum>
        </row>
         <row>
           <Time>TMU/2023/1020 A</Time>
           <Sum></Sum>
         </row>
<row>
        <Time>Debit</Time>
      <Sum>(664,297.52)</Sum> 
     </row>
     <row>
            <Time>56011846 A</Time>
             <Sum></Sum>
             </row>
</root>

Please edit your question and add an example of the input. Consider also reducing the example to the minimum required to demonstrate the problem - see: [mcve]. — michael.hor257k, Jun 12 '23 at 22:07
Hello Michael, thank you for your reply. I have changed the code a bit to the little bit needed. Not sure if this suffices. — OyeRep, Jun 13 '23 at 13:19
I still have no clue what your question is about. What is the input?? — michael.hor257k, Jun 13 '23 at 13:53
Hello Michael, thank you for your past reply. I have added the input. The first output is my current output but the next output is my desired output. — OyeRep, Jun 13 '23 at 14:25
This appears to be a [grouping](https://stackoverflow.com/tags/xslt-grouping/info) problem. Which version of XSLT does your processor support (see: https://stackoverflow.com/a/25245033/3016153)? — michael.hor257k, Jun 13 '23 at 14:34

score 0 · Accepted Answer · answered Jun 13 '23 at 14:51

As I mentioned in the comments, this seems to be a grouping question. If (as you report) your processor supports XSLT 2.0, you should be able to produce the expected output using:

XSLT 2.0

<xsl:stylesheet version="2.0" 
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>

<xsl:template match="/root">
    <Trailer> 
        <xsl:for-each-group select="row" group-starting-with="row[Sum/text()]">
            <Payment>  
                <Reference>
                    <xsl:value-of select="current-group()/Time" separator=","/>
                </Reference> 
            </Payment>
        </xsl:for-each-group>
    </Trailer> 
</xsl:template>

</xsl:stylesheet>

XSLT Concatenation from different nodes when a string is found

1 Answers1