AnsweredAssumed Answered

Count point that have matching attribute

Question asked by kenny.yue on Jul 15, 2020
Latest reply on Jul 16, 2020 by danretired

I'm working with an asset with data that consist of polylines and points. There are a lot of points that are created after work orders from field workers. These point have the same Uid as the specific Line segment. Relationship between line and point are One-to-Many. They are not necessarily intersecting. I would to add a field to the polyline attribute table to show total count of these points are matching with the line Uid.Point and line illustration

Lines

object IdUid
1731000
2731001
3731002
4731003
5722000
6723000

 

Points

object IddateUid
16/4/2020731000
26/4/2020731002
36/12/2020731000
46/12/2020731003
56/12/2020722000
66/19/2020731000
76/19/2020731003
86/19/2020722000
96/27/2020731000
106/27/2020722000

 

Goal:

object IdUidcount
17310004
27310010
37310021
47310032
57220003
67230000

Outcomes