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

23 次查看（过去 30 天）

JFz 2017-12-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/373930-got-error-in-joining-two-tables-left-and-right-key-variables-date-and-date-include-cells-contai

评论： JFz 2017-12-22

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 个评论
显示无隐藏无

KL 2017-12-20

what is left join?

JFz 2017-12-20

I am using outerjoin:

outerjoin(a,b,'Type','left','MergeKeys',true);

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

Peter Perkins 2017-12-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/373930-got-error-in-joining-two-tables-left-and-right-key-variables-date-and-date-include-cells-contai#answer_297406

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 个评论
显示 -1更早的评论隐藏 -1更早的评论

JFz 2017-12-22

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.

请先登录，再进行评论。

请先登录，再回答此问题。