topic Relate Tool not Working in ArcGIS Pro Questions

Relate Tool not Working

OghenemaroAustin-Igbuku — Thu, 23 May 2024 18:12:08 GMT

I have tried to relate an open data feature layer to an open data standalone table. The standalone table contains multiple data relating to individual features within the feature layer. I followed the appropriate steps to relate the unique ID fields in both tables to create the relate but there is no output table. This doesn't change whether I use a csv. file or xlsx. file.

I am not sure what's wrong here, does anyone have any idea how I can fix this?

Re: Relate Tool not Working

KimOllivier — Thu, 23 May 2024 22:46:42 GMT

Relates are only possible with internal feature classes, not external data. You will have to either copy the data into a file geodatabase (always a good first step) or you could use python and dictionaries with cursors to get the related data if you are familiar with scripting.

Re: Relate Tool not Working

OghenemaroAustin-Igbuku — Thu, 23 May 2024 23:37:39 GMT

Thanks, but even after adding the feature class to the geodatabase, and adding the table to the geodatabase, nothing happens when I run the relates tool.

Re: Relate Tool not Working

KimOllivier — Fri, 24 May 2024 02:13:03 GMT

Ok, post up the table schema and attribute schema and your relate expression. there are two types of relate, a Map relate (in memory) and a database relate (stored in the database).

Are both primary and foreign key fields the same? Are they indexed? If they are characters lots of things go wrong with case, leading or trailing blanks, unicode. It is safest to use integers but now esri has wrecked things with Big Integers that don't always work.

What are you expecting with a relate? It is not a join. You can see related records with a popup, or a selection can be transferred with the hamburger options on the table. Otherwise fairly useless for mapping.

Re: Relate Tool not Working

OghenemaroAustin-Igbuku — Tue, 04 Jun 2024 23:34:44 GMT

Okay, thank you for your help and for clarifying the scope of what a relate can do and what I need to look out for. I was able to display the information from my stand alone table without using the relate tool.