Got error in joining two tables: Left and right key variables 'Date' and 'Date' include cells containing non-string values.
24 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentare
Antworten (1)
Peter Perkins
am 22 Dez. 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.
Siehe auch
Kategorien
Mehr zu Time Series Objects finden Sie in Help Center und File Exchange
Produkte
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!