I have 16 shapefiles (listed above). Each shapefile contains county-level data on mortality rates for years 1999 to 2015, respectively. I organized the mortality rate data in Excel. I joined the Excel data to an empty US_county_polygon data map by joining FIPS (commonly used to identify counties in census data).
I am creating a space time cube in ArcMap. Space time cubes require a SINGLE input file with data for all years. I have MULTIPLE input files.
I cannot match my multiple files to the same US_County_polygon reference shapefile. Perhaps, because I join them using FIPS. Each time I join a new single-year shapefile using FIPS to the master US_County_polygon shapefile, it writes over the prior file.
How can I amalgamate the data to create a space time cube?