Description:
There should be an aggregate function for strings which can be conveniently used to concatenate the different values of a text field when grouping, e.g. like
SELECT key1,
key2
SUM(some_numeric_field),
MAX(some_other_field),
CONCAGGREGATE(some_text_field, ", ")
FROM aTable
GROUP BY key1, key2;
Now assume that some_text_field has the following (distinct) values:
abc
def
ghi
Then the result of CONCAGGREGATE(some_text_field, ", ") should be:
"abc, def, ghi"
- it concatenates the strings with the given separator
(of course the function can and should have a prettier name).
That would be a very convenient feature for cases, where you want to quickly include the values from a text field into a rollup for informational purposes without a big fuss like concatenating separately or similar.
That would be a truly pragmatic and innovative feature. Thanks.
How to repeat:
n/a
Suggested fix:
Sorry if there is already a possibility to do this; I'm not aware of one.
Description: There should be an aggregate function for strings which can be conveniently used to concatenate the different values of a text field when grouping, e.g. like SELECT key1, key2 SUM(some_numeric_field), MAX(some_other_field), CONCAGGREGATE(some_text_field, ", ") FROM aTable GROUP BY key1, key2; Now assume that some_text_field has the following (distinct) values: abc def ghi Then the result of CONCAGGREGATE(some_text_field, ", ") should be: "abc, def, ghi" - it concatenates the strings with the given separator (of course the function can and should have a prettier name). That would be a very convenient feature for cases, where you want to quickly include the values from a text field into a rollup for informational purposes without a big fuss like concatenating separately or similar. That would be a truly pragmatic and innovative feature. Thanks. How to repeat: n/a Suggested fix: Sorry if there is already a possibility to do this; I'm not aware of one.