Sunday, 8 September 2019

arcgis desktop - Performing relate in ModelBuilder for one to many relationship?


I'm not sure how to do this as I don't' think there are any ModelBuilder tools for this task. I'm not real savvy with Python but basically I want to relate field1 in table A to field2 in table B with a one to many relationship. So I want all records in table B that match Table A.



Answer



The Add Join (Data Management) tool




Joins a layer to another layer or table (where layer is a feature layer, table view, or raster layer with a raster attribute table) based on a common field.



This can be used in ModelBuilder and supports both one-to-one and many-to-one - if you need one-to-many you should be able to reverse the order of your inputs.


No comments:

Post a Comment

arcpy - Changing output name when exporting data driven pages to JPG?

Is there a way to save the output JPG, changing the output file name to the page name, instead of page number? I mean changing the script fo...