Substitute for join/ outerjoin in cell array?
6 views (last 30 days)
Show older comments
It seems join and outerjoin only work for tables. Is there a substitute for cell arrays?
0 Comments
Accepted Answer
Guillaume
on 6 Sep 2016
Well, you can always convert your cell arrays to a table with cell2table, do the join and convert back.
%INPUTS:
%leftcell: first cell array
%rightcell: second cell array
%leftkeys: column indices for left key
%rightkeys: column indices for right key
%JOIN:
[common, rows] = ismember(leftcell(:, leftkeys), righcell(:, rightkeys), 'rows');
joinedcell = [leftcell(common, :), rightcell(rows, :)];
%OUTERJOIN:
[commonleft, rows] = ismember(leftcell(:, leftkeys), righcell(:, rightkeys), 'rows');
commonright = ismember(rightcell(:, leftkeys), leftcell(:, rightkeys), 'rows');
joinedcell = [leftcell(commonleft, :), rightcell(rows, :)];
joinedcell = [joinedcell; ... normal join
[cell(sum(~commonright), size(leftcell, 2)), rightcell(~commonright, :)]; ... add non matching rows from rightcell
[leftcell(~commonleft, :), cell(sum(~commonleft), size(righcell, 2))]]; ...add non matching rows from leftcell
I've not merged the left and right keys. It's not particularlty hard to do, and you could also select which columns to include in the join, but you should get the idea from the above.
0 Comments
More Answers (1)
KSSV
on 6 Sep 2016
You can join them...
k{1} = 1 ;
k{2} = [2 3] ;
l{1} = [3,4];
l{2} = [5] ;
% join them
kl = [k l] ;
2 Comments
See Also
Categories
Find more on Cell Arrays in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!