I have two layers that are related. My current manual process is as follow;
a. Add the layer 1 to the table of contents
b. Open the attribute table then Switch selection to select all layer 1 records
c. Click relates and select layer 2 This will select all layer 2 records related to the layer 1
d. Switch selection This will display all layer 2 records not related to the layer 1
e. Export the table to excel
I want to automate this using ModelBuilder.
This is where I am using ModelBuilder;
Layer 1 > Select Layer By Attribute (Switch selection) > Calculate Field (I require a python script that is able select all related layer 2 records) > Select Layer By Attribute (Switch Selection) > Export to Excel
findunique("Points1","Points2","Id")