Got error in joining two tables: Left and right key variables 'Date' and 'Date' include cells containing non-string values.
23 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Hi, I have two tables a and b. Both have a column Date as datenum. When I use left join, I got this error: "Left and right key variables 'Date' and 'Date' include cells containing non-string values." One table has 600 records; the other table is very large and has 25000 records. What can be the problem here and how to fix this?
Thanks for any input.
2 comentarios
Respuestas (1)
Peter Perkins
el 22 de Dic. de 2017
The error seems clear: you are trying to use a variable that is not supported as a key. You say that you have a datenum variable, the error suggests that that is not the case, that you have a cell array containing datenums.
If you are using anything like a recent version of MATLAB, you will likely be better of using datetimes.
Ver también
Categorías
Más información sobre Time Series Objects en Help Center y File Exchange.
Productos
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!