Hi, all,
I'm working in Pro 3.4.3. I'm trying to create a join between a layer and a Standalone Table - which is something I've done countless times with no problem. As background, the original layer file I'm working with was a .gpkg. I exported it to a layer file and I hoped that would solve my problem because I was then able to create an attribute index for it.
It sort of worked, in that I didn't get any errors and I could see the new fields from the Standalone Table were added to the table for my new layer, i.e., the tables did join. But none of the values carried over. All of the values in fields from the Standalone Table are <Null>. Every single one.
The layer and the standalone table each have a field "PWSID" that I used for the join. While there may be some errors or records that don't match, there are many that do. I spot checked and can find matching numbers in the two tables. So it's not a matter or the join records not matching. There should be at least some records that have value. But there are none.
Any ideas?
Thank you!!