I have two shapefiles populated by polygons, where several polygons of the second (Supplier) shp intersect the first (Requestor). When it does the Spatial relations and merges the attributes I need it to pick of the maximum attribute value of all the polygons that intersect the Requestor. Basically performing the Join attribute function in other softwares by spatial location picking the maximum value of the Supplier polygons intersecting the Requestor polygon, but can't figure out a way to do so. Does anyone know of a way around this? Thanks.
A diagram might help, so I need a transformer that reads that there are three gardens intersecting the property and then to pick up the maximum cost of the garden and merge it into the output attribute list. It's the last bit I'm struggling with.