Performing a "join on indexed fields" is not working.
...For instance when joining a Feature Class (of 50 States/features) with a Standalone Table of 50 records, the most common result is that only 1 record is joined -- and it's usually the last one in alphabetical order -- which is Wyoming.
This most often happens when one or both the common fields are "Indexed", as noted by the asterisk (*) after field name.
However, when this is "removed" with the 'Remove Attribute Index' tool, it will work.
Is this a BUG? Or, is there some other explanation?
Thanks,
Thanks, Craig E.
Hey Craig
I don't see any csv within the zip but it sounds like using a dBASE format has fixed this. My guess is that the format conversion is fixing a slight issue with something such as the data schema.
If you see this on any other layers then please do raise it with us.
Many thanks,
David