Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
is it possible to sort the result of a concat function by an expression?
Thank you in advance,
Larisa
Can you give an example of what you are trying to accomplish?
Sure:
=concat(field, delimiter, sort)
Ок, thank you!
Is it possible to count the number of values in the string which is the result of a concat function?
Thank you in advance,
Larisa
If I got the question right:
=concat(field, delimiter, sort)
returns the number of values which can be calculated using
=count(field)
If you use "distinct" in concat() - use it in count() too.
Thank you!