Skip to main content
  • EN

Hi,

 

I currently have 2 MapInfo table

 

-First table contains points with fields Id1 and Number1

 

-Second table contains roads with fields Id2 and Number2.

 

 

I would like to calculate Number2=Sum(Number1) when Id1=Id2 AND the points are the closest to the line.

 

The roads are divided into multiple segments but those segments have the same Id2.

Multiple points can be assigned to one segments, and all those points share the same id1=Id2.

 

So I think I should use NeighborFinder but is it possible to only search through segments with the same Id2 ?

 

Thank you

Hi @usertm,

Please copy the Id1 attribute on the points to a new Id2 attribute, then set the Group By in the NeighborFinder to the attribute Id2. This will limit the neighbor searches to points and segments whose ids match.

Reply


Community Stats

30,176
Posts
114,542
Replies
37,835
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.