In QGIS 3.18. In a shapefile attribute table, I need to create a field that concatenates several other fields with a comma delimiter. Some of those fields are NULL.
Currently my approach has been what I thought was the foolproof
"Field1" || ', ' || "Field2" || ', ' || "Field3". If all 3 of these fields contain a non-NULL value, there is no problem (example: Field1=A, Field2=B, Field3=C, result=A, B, C)
However, if one or more fields are NULL, the result is also NULL. (example: Field1=A, Field2=NULL, Field3=C, result=NULL).
I suspect there is a way to account for NULL values in the field calculator without resorting to Python. I do not believe that
coalesce can help me here, but please correct me if I'm wrong.
Note: I'm not concerned with labels here, just attributes.