In point layer A, the locations of farmers' houses are recorded. Each farmer has a unique ID.
In point layer B, the centroids of farmers' plots are included. Each farmer has more than one plot, thus multiple points in the layer B correspond to layer A by farmer ID.
Based on the common farmer ID, I want to calculate the exact distances (not the nearest) from points of each farmer's house in layer A to his or her multiple plots (points) in layer B using QGIS.
I have tried "Distance matrix" as suggested in most of the posts but it doesn't work well.
Any pointers?
The graph above shows a fraction of my dataset. Green points as layer A for farmer's house; Brown points as layer B for plots. One cluster (visually) can be considered as a village. Usually, plots are clustered around the farmers' house (but not always the case).
Virtual layer
?... Another possibility is breaking your plots (centroids) layer to multiple layers according to its farmer ID and try "Distance matrix".