I have a field "istat" that contains multiple values of the istat code (municipal code):
and a table containing the centroids of the municipalities
I am looking for a way to join the "istat"-fields of the two tables in order to create a table with multipoint geometry with the centroids of the common.
I thought of creating as many "istat" columns as the maximum number of "istat"-codes present in a cell, doing a multiple join.
Finally combine all the
geom fields creating a multipoint field (if it is possible to do such a thing).