MapInfo Pro

Welcome to the MapInfo Pro community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Product Documentation  Ideas Portal

Discussions

Members

Resources

Events

 View Only

  • 1.  How To Update Column With Overlapping Polygons

    Posted 11-21-2017 19:18

    I have a polygon layer that some of the polygons overlaps.  I then have a point file.  Updating column is easy, but it will only pull 1 of the values when there is overlapping polygons.  How can I get it to pull both.  Essential,  if Polygon A and B overlap.  When I run update column, it will return saying Point X is inside both Polygon A and B.?



  • 2.  RE: How To Update Column With Overlapping Polygons

    Employee
    Posted 11-24-2017 14:55
      |   view attached

    I have tried to recreate the issue and have a suggestion to address it (Attached Image for Steps described below)

    1. Data represents hypothetical Point layer (Customer point locations) and Polygon layer (representing Store Area).

    2. Do a spatial join of the point layer with polygon layer (i.e. point layer within polygon layer) with point layer as first input.

    3. Open attribute table of join result layer and export this as csv file

    4. Open this csv in Microsoft Office Excel Program and select a blank cell besides the fourth column (here we select cell E2), enter formula =IF(B1<>B2,D2,E1 & "," & D2) into the formula bar [Column reference will differ based on your fields], and then press the Enter key. You get concatenated values of polygon info (Store Name) for Point data (Customer Name).

    Hope this helps!

    -- Thanks, Neena



  • 3.  RE: How To Update Column With Overlapping Polygons

    Employee
    Posted 11-24-2017 15:07
      |   view attached

    Sample data for reference.