My inputs are in this way :
col1 col2 col3
1 a c
1 b c
2 c c
2 d b
2 e z
And I would like to obtain :
col1 col2
1 a, b
2 c, d, e
I tried doing this using the virtual layer and in the query builder using array_agg function but QGIS doesn't seem to recognize this feature.
Ideally I would like to obtain this type of results however :
col1 col2
1 a:c, b:c
2 c:c, d:b, e:z
concatenate(concat("col2",':',"col3"), group_by:="col1", concatenator:=', ')
? – Kazuhito May 15 '18 at 12:48Text(string)
as the output field type. If it is set toWhole number (integer)
the output is null. – Kazuhito May 15 '18 at 15:48