Creating line between two points with same value using QGIS?

Question

I have two separate point layers. The first point layer contains the locations of 100 sensors which are aligned in one specific direction (for example: Asten). The second point layer contains the location-coordinates of the possible directions.

The attribut table of a sensor node looks like following:

The attribut table of a direction node looks like following:

What I am trying to do is to compare each point of point-layer-1 with each point of point-layer-2. If the "location"-attribut of the point-layer-2 node is equal to the "direction"-attribut of the point-layer-1 node, those two points should be connected to a vector. The result should look like this:

The result vectors should be stored in a new line-layer I suppose. Is there a way to do this?

Answer 1

On the sensor layer, go to symbology and change the symbol to a "Geometry Generator". Choose "Line" as type.

Enter the following expression

make_line(
  -- the current feature's geometry (point from sensor layer).
  $geometry,
  -- the matching feature's geometry from the layer 'location_coordinates'
  -- where the attribute 'location' matches the current feature's attribute
  -- "direction"
  geometry(get_feature('locations_coordinates', 'location', "direction"))
)

PS: in this case there will be no new line-layer, but since you "only" suppose, I guess that should be good enough. The up-side is, you can add as many new locations and sensors as you wish or change other data and the lines will just adjust to the data as it is updated.