topic Re: Exported Joined SDE Table Empty in ArcGIS Pro Questions

Exported Joined SDE Table Empty

MeKohler — Mon, 09 Sep 2024 16:50:58 GMT

Hi, I have a polygon layer in a SDE which I joined to a table in a different SDE. The join is successful but when I export the joined layer, the exported layer is empty. I then exported the polygon layer into a file geodatabase, joined it to the table and was able to successfully export the data. The export works when the data is in a file geodatabase but no when its in a SDE.

One thing that I should add is that the primary key in the polygon layer is a text field, while the primary key in the SDE table is Object Id.

Thanks,

Michael Kohler

Re: Exported Joined SDE Table Empty

DanPatterson — Mon, 09 Sep 2024 19:55:59 GMT

The fields should be of the same type and have matching contents for a join to persist

Re: Exported Joined SDE Table Empty

MeKohler — Mon, 09 Sep 2024 20:17:03 GMT

But why does the join work when the polygon layer is in a file geodatabase?

Re: Exported Joined SDE Table Empty

Bud — Thu, 12 Sep 2024 11:23:01 GMT

What version of Pro and what kind of database? For example, Oracle 18c 10.7.1 enterprise geodatabase.

If you cast one of the join fields in a query layer or database view, so that the datatypes are the same, do you still see this issue?

SQL:

SELECT
    CAST(MY_TEXT_FIELD AS INT) AS MY_TEXT_FIELD,
    T.*
FROM
    MY_TABLE T