MATLAB Answers

join tables based on string in one cell in the other

33 views (last 30 days)
jkr
jkr on 9 Feb 2018
Commented: jkr on 9 Feb 2018
I have 2 tables, call them foo and bar. foo has strings in the form "foobar" in column 1. bar has strings in the form 'foobar' in column one.
foo{1,1} = "060514191658"
bar{1,1} = 1×1 cell array {'060514191658'}
foo(1,1) = table CaseID "060514191658"
bar(1,1) = table CaseID '060514191658'
When I try
>> join(foo,bar)
I get:
Error using tabular/join (line 129)
Left and right key variables 'CaseID' and 'CaseID' are not comparable because one is a non-cell.
How do I convert one or another to be able to join on this column.
I've tried every conversion I can think of and still can't get there.

  1 Comment

Sign in to comment.

Accepted Answer

Eric Tao
Eric Tao on 9 Feb 2018
You need to convert strings in foo.var1 to characters, assuming the 1st column name in foo and bar are both 'var1'.
Run:
foo.var1_converted = cellfun(@(x) char(x),foo.var1,'UniformOutput',false);
then you will get a new column 'var1_converted' in foo, which contains the converted characters from strings in column 'var1'.
Then run:
new_tab = join(foo,bar,'leftkeys','var1_converted','rightkeys','var1');
you will get your joined table.

  1 Comment

jkr
jkr on 9 Feb 2018
Excellent, thank you, just what I needed.

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!

Translated by