Labeling information of another atribute

Question

I have this attribute table:

I want to run a script for labelling:

label=''  
parametros=array("Alumínio","Antimônio")

for i in range(len(parametros)):
    label=prof[i]
    if ID_sprof[i]==ID_sprof[i-1]:
        label+=prof[i-1]

This is a try of labeling the Profs of the next attribute together with the previous one. for example, considering that SO-31 has 3 Prof, I wanted one labelling like:

0,6 1,6 3,0

This is a resume of what I'm trying. I know this doesn't work in an expression. But this can be done by making some changes and defining a function in the expression editor.

This is just an example how I could access the information of another atribute to put in the other, but I know it doesn't work.

Answer 1

For QGIS, use this expression:

array_to_string(array_agg(Prof, group_by:=ID_sprof))

You can add an optional argument between the second last and the last closing bracket ) to define (a) delimiter character(s) like this: delimiter:=' ' - what is inside the single quotes ' (here: a space enter code here) will be used as a delimiter. Use \n to insert a linebreak and get a separate row for each value.