Hello
Is it possible to group (concat) certain string values in one column by common value in other column in AC Classic? I've tried with Group By but it's for numerical aggregates and there's a function in postgresql which does that (array_agg) and wondering if it's possible somehow to emulate it with activities? (Having in mind that with SQL Activity it's not possible to make outbound transition with select results)
Eg.
City | Country
------------------------------
Madrid Spain
Barcelona Spain
Paris France
Nice France
Output would be:
Madrid, Barcelona Spain
Paris, Nice France
Kind regards