arcpy: How to select missing records in a related table??

StudentFernie — Wed, 31 Oct 2018 16:08:23 GMT

ok so here is my deal; I am working in an SDE, I have a feature Class of civic address points and these points have a one to many link table also in the SDE. This table is linked by a roll number. Some points are not in the table and some table records are not in the points. What I want top do is have a script that selects all the related records in the link table, switch the selection so the script will then print the non related records by their unique identifier. The purpose of this is to find what records in the link table require points and vice versa.

I need help finding a way to select what records have a relationship.

Ive tried all of these and many more but I cant figure it out:

enterprise geodatabase - Efficiently selecting related records using ArcPy? - Geographic Information Systems Stack Excha…

Select Related Records

https://tutel.me/c/gis/questions/50287/efficiently+selecting+related+records+using+arcpy

What I basically want to do is utilize something like that nice little Select related records button in the attribute table but in python. The reason I require this script is so less "GIS savvy" people in the organization will be able to track down this missing information.

all help and assistance is greatly appreciated

thank you.

Re: arcpy: How to select missing records in a related table??

StudentFernie — Sat, 11 Dec 2021 09:10:36 GMT

#SOLVED WITH THIS SCRIPT 
enterprise geodatabase - Efficiently selecting related records using ArcPy? - Geographic Information Systems Stack Excha… 
its the big one at the bottom of the page.
IF YOU ARE LOOKING, SIMPLY ADD YOUR FEATURES AND TABLES TO THE VARIABLES
ON A FURTHER NOTE, I AM WORKING IN A VERSIONED ENVIRONMENT SO I HAD TO USE BOTH: 
arcpy.MakeFeatureLayer_management and arcpy.MakeTableView_management to accompany my script. 
I am so happy with this and must thank the people who wrote this:  
from here i was able to switch the selection to show my non connected records and print them, the next step 
is to have it export to an excel sheet. so exciting!!

topic Re: arcpy: How to select missing records in a related table?? in Developers Questions

arcpy: How to select missing records in a related table??

Re: arcpy: How to select missing records in a related table??