I am working on a project where I have one shapefile with regional districts of Germany, and another with many small biotope polygons which are overlapping with those regions. Meaning one region contains many of those biotopes. Added to these biotopes are many columns of data.
What I am trying to do, is to add data of exactly one biotope polygon to each polygon in the regions shape. Basically the data of the biotope polygon with the smallest value in column "x" should be added to the region shape file which contains the biotope.
I did find the join by location summary function, but of course then it only adds the smallest value of column "x" to the polygon, but not all the other values.
Since I am still quite new to QGIS I might be missing an obvious solution.
How do I add the data from one (of many) polygon to a second one containing the first, but only if the first polygon has the lowest value in column "X"?