How to check if XML has same values in different nodes using XSLT?

Question

I am very new to XSLT and want your help

I have an XML with below format :

    <?xml version="1.0" encoding="UTF-8"?>
<Rowset>
       <Row>
               <ActualHour>0.64</ActualHour>
       </Row>
       <Row>
               <ActualHour>0.64</ActualHour>
       </Row>
       <Row>
               <ActualHour>0.64</ActualHour>
       </Row>      
</Rowset>

I want to know how can I check whether "ActualHour" has same values across different "Row" node using XSLT?

Thanks in advance.

michael.hor257k · Accepted Answer · 2020-07-02 14:10:55Z

1

Try:

<xsl:template match="/Rowset">
    <output>
       <xsl:value-of select="not(Row/ActualHour!=Row/ActualHour)"/>
    </output>    
</xsl:template>

The result in your example will be:

<?xml version="1.0" encoding="UTF-8"?>
<output>true</output>

With an input like:

<Rowset>
       <Row>
               <ActualHour>0.64</ActualHour>
       </Row>
       <Row>
               <ActualHour>0.65</ActualHour>
       </Row>
       <Row>
               <ActualHour>0.64</ActualHour>
       </Row>      
</Rowset>

the result will be false.

edited Jul 2, 2020 at 14:10

answered Jul 2, 2020 at 13:43

michael.hor257k

118k6 gold badges36 silver badges55 bronze badges

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

5 Comments

Anish Vyas Over a year ago

Thank you. It works like a charm. If you don't mind, the .. is it used as a foreach here?

michael.hor257k Over a year ago

Not sure what you mean by that.

Anish Vyas Over a year ago

In your anser, you mentioned this line : "[ActualHour!=../Row/ActualHour]". How exactly does it work? Like a for loop?

michael.hor257k Over a year ago

It works like a set comparison, because that's what it is. According to the XPath specification, "the comparison will be true if and only if there is a node in the first node-set and a node in the second node-set such that the result of performing the comparison on the string-values of the two nodes is true."

Anish Vyas Over a year ago

Thank you Michael :)

Collectives™ on Stack Overflow

How to check if XML has same values in different nodes using XSLT?

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related