I'm trying to join two datasets together in order to visualise changes over time.
I created a polygon shapefile feature layer showing 9 different sections of an area, with the names of the sections in one column. I then have a standalone table with a column also containing the names of the sections, but this has 45 rows instead of 9 as there are 5 years worth of data.
When I either add a join or use the join field tool, the resulting table/layer contains only the first year worth of data. Is there any way I can get the output dataset to have the 45 rows that I need, so that I can visualise the data by time and section?
Thanks
