Evolution of the aggregate transformation


Could we have a few options more in the aggregate transformation.
I use a lot the concatenate.
Could we include or exclude the empty and ‘’ values from the concatenate.
Could we have an order by option based on another field or on the values concatenated.
if we have 2 or more fields to concatenate, it’s quite hard to get a consistent order of the values we get.

In the pivot transformation, could we have concatenate option, ‘Any’ is great but limited.