Tables: Join on numeric keys

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 件のコメント

Kirby Fears
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.

サインインしてコメントする。

回答 (0 件)

カテゴリ

ヘルプ センター および File ExchangeTables についてさらに検索

タグ

質問済み:

2015 年 11 月 25 日

編集済み:

2015 年 11 月 25 日

Community Treasure Hunt

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

Start Hunting!

Translated by