topic Make a Query Table for One to Many Join in ArcGIS Pro Questions https://community.esri.com/t5/arcgis-pro-questions/make-a-query-table-for-one-to-many-join/m-p/104399#M4242 <HTML><HEAD></HEAD><BODY><P>Hello! I'd like to create a time series animation/series of maps using data that is tied to ZCTAs (ZIPs). I have a feature layer of polygons for each ZIP and then I have a standalone table that has a series of demographic variables for each ZIP across 8 years. So, each ZIP entry has 8 entries in the demographic table that need to be joined to it. I'm trying to use the Make Query Table tool to accomplish this, however when I run that tool, I end up with a table that has millions of entries. It should be around 14,000 (I'm working just with the ZIPs in California). The SQL expression I'm using is 'Table1.ZCTAID' = 'Table2.ZCTAID' ... I'm fairly new to ArcGIS Pro and it's been about a year since I was using it frequently so I'm a little rusty. I appreciate any suggestions or pointers for where I can take this next. Please let me know if there is any additional information that I'm not putting here.</P><P></P><P>Thank you in advance for your help!</P></BODY></HTML> Thu, 13 Feb 2020 03:03:20 GMT ChristopherSalem 2020-02-13T03:03:20Z Make a Query Table for One to Many Join https://community.esri.com/t5/arcgis-pro-questions/make-a-query-table-for-one-to-many-join/m-p/104399#M4242 <HTML><HEAD></HEAD><BODY><P>Hello! I'd like to create a time series animation/series of maps using data that is tied to ZCTAs (ZIPs). I have a feature layer of polygons for each ZIP and then I have a standalone table that has a series of demographic variables for each ZIP across 8 years. So, each ZIP entry has 8 entries in the demographic table that need to be joined to it. I'm trying to use the Make Query Table tool to accomplish this, however when I run that tool, I end up with a table that has millions of entries. It should be around 14,000 (I'm working just with the ZIPs in California). The SQL expression I'm using is 'Table1.ZCTAID' = 'Table2.ZCTAID' ... I'm fairly new to ArcGIS Pro and it's been about a year since I was using it frequently so I'm a little rusty. I appreciate any suggestions or pointers for where I can take this next. Please let me know if there is any additional information that I'm not putting here.</P><P></P><P>Thank you in advance for your help!</P></BODY></HTML> Thu, 13 Feb 2020 03:03:20 GMT https://community.esri.com/t5/arcgis-pro-questions/make-a-query-table-for-one-to-many-join/m-p/104399#M4242 ChristopherSalem 2020-02-13T03:03:20Z