The example above shows multiple features at one point in time, but there are thousands of features and about 30 hours/timesteps.
I'm trying to get QGIS' Time Manager to read both into itself.
I tried creating a new column of data. I created a 22-character wide string and populate the column with
concat("DATE",' ', "TIME")
and it outputs the following
The second column I used
just to try this way as well.
So the output looks okay and I try to load the layer into QGIS, choosing one of my new columns. It defaults to "SECONDS FROM EPOCH (float)" and the slider starts at the beginning of UNIX time, 1970-01-01.
When I try to force Time Manager to '%Y-%m-%d %H:%M:%S' or '%Y-%m-%dT%H:%M:%S', it fails and gives me the following error.
I saw this question from several months ago that seems to be similar to my problem but it doesn't look like they got a solution. Wondering if anyone can help me? I thought strings would work but perhaps I'm missing something.
EDIT: Here are the fields I have and their properties. Is there a difference between 'String' and 'string'? I created all the original fields in Fortran and I notice the new fields I made in QGIS are labelled as 'string'.
Interestingly, if I set Time Manager to treat the data as "SECONDS FROM EPOCH (float)" (i.e. manually setting it, rather than letting it figure it out), I get the following error
Some data to reproduce the issue can be found here, I'll leave it for about a day.