James Bond Allen Bond
Geek Answers Handbook

XQuery - group and account

This is the structure of my xml file -

<A> <Name t="Mr.">James Bond</Name> <Name t="Mr.">Allen Bond</Name> <Name t="Mr." p="X">James Bond</Name> <Name t="Mr." p="X">James Bond</Name> <Name t="Mr.">James Bond</Name> <Name t="Mrs.">James Bond</Name> <Name t="Mrs.">James Bond</Name> <Name t="Mr.">James Bond</Name> <Name t="Mrs." p="Y">James Bond</Name> <Name t="Mrs." p="Y">James Bond</Name> </A>

Expected Result -

 <A> <N>Allen Bond Mr - 1</N> <N>James Bond Mr - 3</N> <N>James Bond Mr, X - 2</N> <N>James Bond Mrs - 2</N> <N>James Bond Mrs, Y - 2</N> </A>

I can get different names, but I can’t add an account ...

+4
source share
1 answer

XQuery 3.0 solution with group by :

 <A>{ for $name in //Name let $full := if(not($name/@p)) then concat($name, ' ', $name/@t) else concat($name, ' ', $name/@t, ', ', $name/@p) group by $full return <N>{$full, '-', count($name)}</N> }</A>

XQuery 1.0 solution with distinct-values($arg) :

 <A>{ let $names := for $name in //Name return if(not($name/@p)) then concat($name, ' ', $name/@t) else concat($name, ' ', $name/@t, ', ', $name/@p) for $name in distinct-values($names) return <N>{$name, '-', count($names[. eq $name])}</N> }</A>
+5
source

More articles:


All Articles