I have a polygon layer that I want to combine with a data table using a spefic join field which exist in both layer and data table. Layer and table are stored in the same geodatabase. The challenge is that the data table contains multiple entries per spatial unit. These are month-year values (YYYYMM). I want to visualize this time data using the time slider. How can I link the layer and table so that not just the first value in the table is used, but all of them, so that the visualization can be done by symbolizing all values? My understanding is that the polygons in the layer would need to be duplicated in order to physically represent the monthly values. Is this possible, and if so, how?
I think I found the answer by myself: In my first tries, layer and standalone table were in different gdbs which resulted in not having the one-to-many connection option. After saving both in the same gdb, the one-to-many option appeared and all rows of the table could be connected to the polygon layer.