General

Re: XPath: Count distinct values in repeating table

zaphi — Mon, 03 Dec 2007 08:56:18 GMT

Hi Chris,
Your solution is very good. Thank you very much!

here my sample:
count(../my:gruppe1/my:gruppe2/my:feld2[not(preceding::my:gruppe2/my:feld2 = .)])

Best regards
Philippe

Re: XPath: Count distinct values in repeating table

anotherchrisberry — Fri, 30 Nov 2007 22:26:36 GMT

you can use a simple xpath like this:

count(row[not(preceding::row = .)])

that will give you the count of distinct values.

Re: XPath: Count distinct values in repeating table

Karsten Brocksieper — Thu, 29 Nov 2007 08:34:57 GMT

Hello,

even if the following article by Tim Pash is not regarding a repeated table --- but maybe the technique can be helpful for you to accomplish your task...

Please have a look at: http://blogs.msdn.com/timpash/archive/2005/11/23/XPATH-Filtering-Distinct-Values.aspx

HTH,

XPath: Count distinct values in repeating table

zaphi — Thu, 29 Nov 2007 07:50:01 GMT

Hi
I need to count the distinct values of a field in a repeating table, which contains the name of a person
Example:
row1: Name = "Smith"
row2: Name = "Bird"
row3: Name = "Smith"
row4: Name = "Walker"

count of distinct values: 3

Can anybody tell me, how I can manage that with XPath.
Thanks a lot.
Best regards.
Philippe