I'm using ArcGIS Pro. I have a CSV file that contains an attribute for regions' values over time in multiple records: One record per region and date. Also, I have a feature layer for the regions...polygons. A join field exists between these two datasets.
How do I "convert" the CSV file to a new feature layer using the existing Region feature layer's geometry.
My goal is to use the date attribute in the Time properties to create an animation. I also have a pivoted version of the CSV, which could be joined to the region feature layer easily. But I don't know how to unpivot and then convert the column names to a Date value / data type.