|
Subject: Re: [xsl] How to count the distinct values where elements with missing child are counted as one of the distinct values? From: "Dimitre Novatchev dnovatchev@xxxxxxxxx" <xsl-list-service@xxxxxxxxxxxxxxxxxxxxxx> Date: Fri, 27 May 2022 21:10:12 -0000 |
One correction:
let $test := /test/row
return
count(distinct-values($test/transition))
+xs:integer(exists($test[not(transition)]))
On Fri, May 27, 2022 at 8:09 AM Dimitre Novatchev <dnovatchev@xxxxxxxxx>
wrote:
> > Use count(distinct-values(/test/row/string(transition)))
>
> I would use the more obvious and self-explanatory:
>
> let $test := /test/row
> return
> count(distinct-values($test/transition)) + 1[$test[not(transition)]]
>
> If this XPath evaluation is initiated from an XSLT transformation and XSLT
> 1.0 compatibility set to true (Specifying version = "1.0" but using an XSLT
> 2.0 or later processor), one can use even:
>
> count(distinct-values(/test/row/transition)) +
> boolean(/test/row[not(transition)])
>
>
> Thanks,
> Dimitre
>
> On Thu, May 26, 2022 at 7:33 AM Michael Kay mike@xxxxxxxxxxxx <
> xsl-list-service@xxxxxxxxxxxxxxxxxxxxxx> wrote:
>
>> Use count(distinct-values(/test/row/string(transition)))
>>
>> string() applied to an empty sequence returns the zero-length string,
>> whereas atomization applied to an empty sequence returns an empty sequence.
>>
>> Michael Kay
>> Saxonica
>>
>> > On 26 May 2022, at 15:08, Roger L Costello costello@xxxxxxxxx <
>> xsl-list-service@xxxxxxxxxxxxxxxxxxxxxx> wrote:
>> >
>> > Hi Folks,
>> >
>> > The following XML document has two row elements with no transition
>> element and two row elements with a transition element :
>> >
>> > <test>
>> > <row>
>> > </row>
>> > <row>
>> > </row>
>> > <row>
>> > <transition>ABC</transition>
>> > </row>
>> > <row>
>> > <transition>DEF</transition>
>> > </row>
>> > </test>
>> >
>> > I want a count of the number of distinct transition values, where row
>> elements with no transition element are counted as 1.
>> >
>> > So for the above XML document the count should return 3.
>> >
>> > This XPath seems to work:
>> >
>> > count(distinct-values(/test/row/transition)) +
>> count(/test/row[not(transition)][1])
>> >
>> > But I am wondering if there is a better (simpler, less kludgy) XPath
>> expression?
>> >
>> > /Roger
>> >
>> >
>>
>>
>>
>
> --
> Cheers,
> Dimitre Novatchev
> ---------------------------------------
> Truly great madness cannot be achieved without significant intelligence.
> ---------------------------------------
> To invent, you need a good imagination and a pile of junk
> -------------------------------------
> Never fight an inanimate object
> -------------------------------------
> To avoid situations in which you might make mistakes may be the
> biggest mistake of all
> ------------------------------------
> Quality means doing it right when no one is looking.
> -------------------------------------
> You've achieved success in your field when you don't know whether what
> you're doing is work or play
> -------------------------------------
> To achieve the impossible dream, try going to sleep.
> -------------------------------------
> Facts do not cease to exist because they are ignored.
> -------------------------------------
> Typing monkeys will write all Shakespeare's works in 200yrs.Will they
> write all patents, too? :)
> -------------------------------------
> Sanity is madness put to good use.
> -------------------------------------
> I finally figured out the only reason to be alive is to enjoy it.
>
>
--
Cheers,
Dimitre Novatchev
---------------------------------------
Truly great madness cannot be achieved without significant intelligence.
---------------------------------------
To invent, you need a good imagination and a pile of junk
-------------------------------------
Never fight an inanimate object
-------------------------------------
To avoid situations in which you might make mistakes may be the
biggest mistake of all
------------------------------------
Quality means doing it right when no one is looking.
-------------------------------------
You've achieved success in your field when you don't know whether what
you're doing is work or play
-------------------------------------
To achieve the impossible dream, try going to sleep.
-------------------------------------
Facts do not cease to exist because they are ignored.
-------------------------------------
Typing monkeys will write all Shakespeare's works in 200yrs.Will they write
all patents, too? :)
-------------------------------------
Sanity is madness put to good use.
-------------------------------------
I finally figured out the only reason to be alive is to enjoy it.
| Current Thread |
|---|
|
| <- Previous | Index | Next -> |
|---|---|---|
| Re: [xsl] How to count the distinct, Dimitre Novatchev dn | Thread | Re: [xsl] How to count the distinct, Mukul Gandhi mukulg@ |
| Re: [xsl] How to count the distinct, Dimitre Novatchev dn | Date | Re: [xsl] How to count the distinct, Dimitre Novatchev dn |
| Month |