Hey everyone, this is my first GeoNet post so forgive me if I've asked my questions in the wrong place!
The goal of my current project is to create a map animation of global COVID-19 case numbers, where the animation shows changing daily case numbers, symbolized by graduated symbols. The COVID data that I have is just a table with various data for every country, every day, since 12/31/2019. I cannot join it to a country feature class because it would be a 1:M cardinality, and I'd be unable to symbolize the data. So I've attempted to use model builder to automate the querying, joining, and exporting processes. I created one workable model that allowed me to query the COVID data, join the queried data to a country feature class, and create a permanent feature class from that. This means, however, that I would need to go in and change the date variable over and over, manually, to create new feature classes for each date. So, I tried to understand the use of - and then utilize - iterators, to create everything I wanted with one button click.
I tried the Iterate Field Values iterator, so that the model would take each date (of which there are 230+ records for each date, because each country is represented in the table), and create a new table from it. Then the model would join that date table to the country feature class, and create a new permanent feature class. This new FC I would use for my animation. However, I received an error at the iterator part of the model, and cannot figure out how to fix it (one error is an unexpected error that needs a bug report submitted). I've attached photos of the model, error window, and COVID table snippet.
This is my first time using model builder, and I know I'm doing something wrong. Any help would be appreciated! And, let me know what other info you may need, as I'm sure what I've provided is not exhaustive.