Make Query Table: SQL not working

LindsayTrujillo — Sun, 23 Apr 2017 22:41:45 GMT

Problem: I am trying to create a Time Series Animation of Census Population in Chicago from 1930 to 2010 (per 10 years) by Community Areas (77).

I already transposed the data, ensuring that every community area feature had a population estimate per 10 years with a final record count of 693.

However, I am having trouble with the 'Make Query Table' step. I am trying to make a one to many join by Community Area name. Here is how it already looks like.

Here is the attempted query:

The query is verified, but no records were returned. (I attempted to remove the quotes but generated an error message when I clicked 'OK' on Query Builder and Make Query Table.)

I heard that this could've been a potential bug, so I went through with that query and my final table was not appropriate. I had the same 693 records, BUT the 'CommunityAreasFC.community' field repeated only 1 community area value ('DOUGLAS').

I reversed the query ('widedataset_transposefields.Comm_Areas'='CommunityAreasFC.community') and had a different output, but same problem. 77 records were produced with 'widedataset_transposefields.Comm_Areas' field repeating 'Rogers Park' for all values.

What am I missing in my query? I am working in ArcGIS 10.4 and working in a geodatabase.

Thank you!

topic Make Query Table: SQL not working in Data Management Questions

Make Query Table: SQL not working