I have 1.000 point layers (shapefiles).
How can I find points intersected to a line without defining the points layer?
Because defining thousand layer takes time. And I dont wanna merge those point layers because I need it for visual purpose.
aggregate(layer:='point1',aggregate:='sum',expression:="number",filter:=intersects($geometry, geometry(@parent))) + aggregate(layer:='point2',aggregate:='sum',expression:="number",filter:=intersects($geometry, geometry(@parent)))
1st problem : i got wrong sum result after the first line i draw ( i want duplicate points only count once)
2nd probelm : imagine i have 1000 layers of points, it is so hard to type them all. So i need generalization for N points layer or any solution which doesnt require to define points layer.
I was thinking of another option to get correct sum number.
Maybe we can merge these two column, so the yellow-highlighted line one group into one.