Filter löschen
Filter löschen

Got error in joining two tables: Left and right key variables 'Date' and 'Date' include cells containing non-string values.

29 Ansichten (letzte 30 Tage)
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.

Antworten (1)

Peter Perkins
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.
  1 Kommentar
JFz am 22 Dez. 2017
Thanks. I found out what the problem was: The keys were arrays of cells. I converted the cell array into array of doubles. I will post the answer soon.

Melden Sie sich an, um zu kommentieren.


Mehr zu Time Series Objects finden Sie in Help Center und File Exchange



Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by