Adding joins on multiple tables to a single table in Pro 3.1

Jay_Gregory — Thu, 21 Dec 2023 18:59:15 GMT

I am running into a strange issue when I try to join multiple tables to a single base table. I have 4 tables, all related to each other through a unique string column. Table A is my "base" table. I want to add joins for tables, B, C, and D to table A, and publish to AGOL. I don't want to permanently join, just use the add join dialog. There are a lot of similarly named fields in the tables, but also a good bit of different information. And these are 1 to many or none relationships.

I can usually add two tables as joins (e.g. add joins for B and C to A, or D and B to A, etc.). However, when I try to add the final join, Pro throws an error

arcgisscripting.ExecuteError: ERROR 001486: Cannot use fields from joined tables.
Failed to execute (AddJoin).

I really don't know what to make of this. Anyone have experience or insight here?

Re: Adding joins on multiple tables to a single table in Pro 3.1

YiQiang2 — Tue, 22 Oct 2024 17:28:42 GMT

I'm having exactly the same issue in Pro 3.3.2. Couldn't join multiple tables one by one. It was possible in 3.0

topic Re: Adding joins on multiple tables to a single table in Pro 3.1 in ArcGIS Pro Questions

Adding joins on multiple tables to a single table in Pro 3.1

Re: Adding joins on multiple tables to a single table in Pro 3.1