same problem... v 10.2.2
Relate works but with the same settings "- No matches found by joining"
(all fields with attribute index)
upd:
For my case i fix it by exporting both tables in same gdb
(reindexing or compact DB wasn't solving problem)
Joe,
Can you post sample data? Are you using 10.0 or 10.0sp5?
Lance Shipman
Geodatabase Product Engineer, File Geodatabase, SQLite, Shapefile
esri, Redlands
Lance- I started this thread 3 years ago in the old forum. I was only 54 then.... In my advancing years, I can not for the life of me remember how I got it to work, but it's a non-issue for me now....
Lance- lo and behold... A few years later and I've stumbled upon the problem again. Using v10.0 SP5. I was actually trying to troubleshoot another forum users' problem and this resurfaced.
Here is the scoop:
I have a point feature class with a text-type field to join to a text-type field in another table. I initially set the table up such that it would support a 1:1 relationship and a subsequent join and it worked fine. Here is a screen shot of the points table Joined via the JoinItem field to the datatable (which is shown in the lower portion of the table view window)
Then I altered the table such that it had multiple records, changing the relationship from 1(point) to Many(records in table).
No problem right? I'll just use a summary to get a total for the attribute I want to label the points: so I Summarize on the common join-item in the stand alone table, getting the count of each instance of the join-item and a summary of the values:
But when I try to join the point feature class attribute table with the summary table, I can't:
If you want me to send the data, let me know where to....
Your best bet is to contact Technical Support. They have a standard procedure for downloading data.
Lance- Today I'm on a 10.2.2 machine, and I did the same thing as yesterday. Everything works here so I think it's not an issue.....