Hi,
   How to do the unique grouped values which stored as attribute in the tag using xpath....?

Here is my xml data;

<xml>
    <s:Schema id='RowsetSchema'>
      ....
    </s:Schema>
<rs:data>
    <z:row Region='Asia' City='Coimbatore' Category='AAA' Amt='90'/>
    <z:row Region='Asia' City='Coimbatore' Category='BBB' Amt='91'/>
    <z:row Region='Asia' City='Singapore' Category='AAA' Amt='92'/>
    <z:row Region='Asia' City='Chennai' Category='BBB' Amt='93'/>
</rs:data>
<xml>

Here Im using the xpath in javascript in .Net 2.0 also in VBA;
....
xmlNode = xml.selectNodes("//z:row[not(@Category=preceding-sibling::*/@Category)]/@Category");
....

Seems to be very slow when having huge data. I have tried using "distinct-values", but it's throwing error "Unknown method".

Here I want to get the output as like AAA,BBB,CCC... using xpath in javascript and also for VBA using MSXML2.

Pls help me out to solve this problem...

Thanks in advance:)


viv

__________________
vivek

Well this would be very slow, because for the nth node it will have to check every attribute of the preceding n-1 nodes.

The reason distinct-values doesn't work is that its a XSLT 2.0 function, and neither Microsoft processor supports XSLT 2.0.

I can't think of a better way of doing this in one line of XPath - sorting the nodes by Category and just looking at the previous node would be quicker I suspect, but that's not as easy as it sounds, due to the preceding-ssibling axis always being original document order.

/- Sam Judson : Wrox Technical Editor -/

 yes, I know..., but i want the alternate solution(xpath and its functions which supports in .Net 2.0 @client side javascript also for VBA MSXML2)

Thx!

viv

Like Sam, I can't really offer any easy answer, given that you're stuck with XPath 1.0. The best answer might be to iterate over the sibling elements from Javascript, adding each value to a set of values maintained at the Javascript level.

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

Thx Sam and MhKay!

   Can u help me to write an XSL to iterate instead of using javascript and I'll transform using javascript.

Pls help me!

Thank you!

viv