Tables: Join on numeric keys

Christoph

2015 11 25

0 个回答

2 次查看（30 天）

0 个投票

Is there a way to do a join on tables using numeric variables as keys? I get the following error message:

Left and right key variables 'Key' and 'Key' include cells containing non-string values.

I know that I could maybe use something like num2str, but that does not seem very efficient, as I have to do it on large tables and inside loops (i.e. many times)...

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Kirby Fears 2015-11-25

编辑：Kirby Fears 2015-11-25

This error often happens when you have a cell array containing some strings and some numbers.

If the Key variable is entirely numeric, try converting it to a double array using cell2num. If that fails, then you probably have strings and numeric data mixed together in your Key variable.

A double array or a cell array of strings should work as a Key variable. I'm not sure if a cell array of doubles works or not.

请先登录，再进行评论。

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

Follow Question