ArcGIS PRO - Records disappeared from the table when joining tables

Question

Hello everyone,

Does anyone experience missing records after joining tables in PRO?.. I just lost (gone from dataset ) all 60 records (records that matched the join table) of the input Table. The records disappeared from the main table after I removed the join! Frustrated!!!!!

FYI: using ArcGIS PRO 2.8.2 and AGOL hosted tables - data owner.

JB

JoseBarrios1 · Answer

Agree!.. I usually work on a copy and I overwrite the AGOL file later. However, the overwrite sometimes brake the dashboard and Exp. builder App filters and functions. There is no winning workflow!

RhettZufelt · Answer

Sorry to hear that.  My example was with local database data, not AGOL in Pro 2.9.2.

However, been using ESRI stuff long enough, I don't try ANYTHING with the data until I have a copy of it.  Especially AGOL data.  Seems like it is just a matter of time before something goes wrong and need to recover from backup(s).

R_

JoseBarrios1 · Answer

Hello RhettZufelt,

Thanks for your comments! I did try  closing  and opening the file on a new PRO project.. All records are mysteriously  gone! Both tables are hosted on AGOL  and I was just using one table to copy attributes from another table using the "calculate field" tool in PRO. I did a table join using  a common key field and then I selected a sub-set using one of the field categories (taxa =Reptiles).  After successfully copying the data, I removed the join and ALL the previously selected records ( all 60 reptiles record ) were deleted. The actual records ( no just blank) were removed from the table. It also deleted the records from the AGOL version.