Join not working on Indexed fields

[Craig_Eissler_Iceman]

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.

[David_McRitchie]

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

[Craig_Eissler_Iceman]

Hello David, and sorry about that last Zip file.

Please try this version and see what happens on your end ...if you don't mind?