Select to view content in your preferred language

FGDB — Join from table to database view: Join fields are null

528
1
Jump to solution
05-08-2023 08:20 AM
Bud
by
Esteemed Contributor

ArcGIS Pro 3.1.1; file geodatabase

I have a FGDB table called TEST_TABLE.

I've created a database view on the table called TEST_TABLE_NT_FLAG_VW:

select objectid, case when type = 'NT' then 1 else 0 end as flag from test_table 

I've opened the table in the map and created a join via the OBJECTID.

Bud_1-1683559121556.png


Result:

The join didn't work. The join fields are null in the attribute table:

Bud_0-1683558803987.png


Video:


Question:

Why are the join fields blank in the FGDB join?

I don't have that problem in mobile or enterprise geodatabases.

0 Kudos
1 Solution

Accepted Solutions
Bud
by
Esteemed Contributor

Esri Case #03335352 - FGDB — Join from table to database view: Join fields are null

BUG-000158140: ArcGIS Pro: Join from table to database view generate Join fields with null values

View solution in original post

1 Reply
Bud
by
Esteemed Contributor

Esri Case #03335352 - FGDB — Join from table to database view: Join fields are null

BUG-000158140: ArcGIS Pro: Join from table to database view generate Join fields with null values