Tables: Join on numeric keys

2 Ansichten (letzte 30 Tage)
Christoph
Christoph am 25 Nov. 2015
Bearbeitet: Kirby Fears am 25 Nov. 2015
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 Kommentar
Kirby Fears
Kirby Fears am 25 Nov. 2015
Bearbeitet: Kirby Fears am 25 Nov. 2015
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.

Melden Sie sich an, um zu kommentieren.

Antworten (0)

Kategorien

Mehr zu Data Type Conversion finden Sie in Help Center und File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by