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!
... View more