any
any(T.a : ‘a) 🡒 boolean, aggregator
Returns true if the group is not empty, and false otherwise.
Example:
table T = with
[| as B |]
[| "a" |]
[| "a" |]
[| "b" |]
[| "b" |]
[| "c" |]
table G[gdim] = by T.B
where T.B != "c"
show table "" a1b4 with
gdim
any(T.*)
group by gdim
any(T.a : boolean) 🡒 boolean, aggregator
Returns true if any grouped value is true, and returns false otherwise.
Example:
table T = with
[| as A, as B |]
[| true, "a" |]
[| true, "a" |]
[| true, "b" |]
[| false, "b" |]
[| true, "c" |]
table G[gdim] = by T.B
where T.B != "c"
show table "" a1b4 with
gdim
any(T.A)
group by gdim
The aggregator returns false on empty groups.
any(T.a : number) 🡒 boolean, aggregator
Returns true if any grouped value is non-zero, and returns false otherwise.
Example:
table T = with
[| as A, as B |]
[| 1, "a" |]
[| 1, "a" |]
[| 1, "b" |]
[| 0, "b" |]
[| 1, "c" |]
table G[gdim] = by T.B
where T.B != "c"
show table "" a1b4 with
gdim
any(T.A)
group by gdim
The aggregator returns false on empty groups.
any(T.a : text) 🡒 boolean, aggregator
Returns true if any grouped value is non-empty, and returns false otherwise.
Example:
table T = with
[| as A, as B |]
[| "foo", "a" |]
[| "foo", "a" |]
[| "foo", "b" |]
[| "", "b" |]
[| "foo", "c" |]
table G[gdim] = by T.B
where T.B != "c"
show table "" a1b4 with
gdim
any(T.A)
group by gdim
The aggregator returns false on empty groups.