ArcGIS Online Table Join fails without explanation

Question

Goal

Create a one-to-many join between a hosted feature layer and hosted standalone table on a common string field.

Data

* TEST_trees (Hosted Feature Layer)
* TEST_species (Hosted Standalone Table

Summary

TEST_trees contains individual records of trees (randomly created in this instance) each with a string value for the field COMMONNAME.

TEST_species contains a single record for each tree species. The field  Common_name_type_first is a unique, string field. The values in this field were used to generate the values for COMMONNAME in TEST_trees.

I have attempted to carry out every combination of tabular join using the Join Features analysis tool in ArcGIS Online.

Join TypeTarget LayerTarget  FieldJoin LayerJoin Fieldone-to-oneTEST_treesCOMMONNAMETEST_speciesCommon_name_type_firstone-to-one

TEST_speciesCommon_name_type_firstTEST_treesCOMMONNAMEone-to-manyTEST_treesCOMMONNAMETEST_speciesCommon_name_type_firstone-to-manyTEST_speciesCommon_name_type_firstTEST_treesCOMMONNAME

Each of these failed. Each produced the error "Unable to add feature service definition" with the exception of the join condition in row 1. It returned the error "JoinFeatures failed."

I was able to successfully carry out the join using the layers linked above using ArcGIS Pro. I have examined the documentation on joins in ArcGIS Online and have been unable to ascertain from it why this join would fail. I have made the data listed above public and available for download. Any ideas of what I might be missing here?

JenniferSmits · Answer

Just writing this down for my future self's sake (and others) - my successful workaround was to make a view of the offending feature layer (originally published from survey123) - no special settings. Then join the view (which i realise creates a view of a view) but it works! In Map Viewer Classic.

Anonymous User · Answer

Yeah, one of those details I failed to add in the heat of my troubleshooting. Thanks again for taking the time to help we work this out.

Joseph_Kinyon · Answer

Oh yes, I think it's because the geodatabas is indexed and the Excel is not.

I did not know these details, I believe you introspection on your workflow is correct.

Joe