In QGIS 3.16. I am using the Aggregate function to reduce the number of features in a layer. I am grouping by one field and I want to concatenate the others.
My actual data table is fairly large and the operation seems to be working for some of my fields, but for some fields, I get an error message related to the concatenation, and for the life of me I can't figure out why.
Here is a screenshot of my Aggregate setup for a truncated version of my table, with a few of the features that are having problems. I am grouping by the field
"Complexe"; note that all output field types are set to String (Text) with a length of 100, so that is not the issue:
Evaluation error in expression "concatenate("ID_CH","Complexe",TRUE,',')": Could not calculate aggregate for ID_CH. Execution failed after 0.86 seconds.
Here are the files if you'd like to try and reproduce the problem: https://drive.google.com/drive/folders/1nOV1dxZWzNiIg9F77brQ36Rcvoze8QSb?usp=sharing