combine cells with unequal dimensions

i have two tables ( A 13*52 cell & B 19*75 cell )

A

& B

first column in each(A & B) has a some duplicated numbers ( 4368042 - 4324685 - 4321114 )

i want to found duplicated numbers in first columns and if exist copy all rows of it

to a new table consists of [ A , New B]

New B = only duplicated numbers ( 4368042 - 4324685 - 432111)

i write this code:

 clear all; clc
tic
[ndata2 text2 alldata2] = xlsread('datecode.xlsx','devtex');
[ndata text alldata] = xlsread('datecode.xlsx','mdr');
[R1,C1]=size(alldata2);
[R2,C2]=size(alldata);
colsize=max(C1,C2);

 for i=1:size(alldata,1)
    for j=1:R1              %length(Defs)
        if alldata2{j,1}==alldata{i,1}
           data1(j,:)=alldata(i,:);  
        end
    end
end

 new_table=[alldata2,data1];

but i got an error in the last line :

CAT arguments dimensions are not consistent.

Error in ==> mdrtry at 37

new_table=[alldata2,data1];

how i can solve this ?

[Amr Hashem]

if any one has an idea to enhance this code?

i wrote another code first but i can't complete it:

          querydevt=alldata2(:,1); 
          querymdr=alldata(:,1);
          a1 = cat(1,querydevt{:});
          a2 = cat(1,querymdr{:});
          idx = ismember(a2,a1);  
          idx2 = [alldata(idx,:)];

[Amr Hashem]

I am waiting for any answer :)

[Walter Roberson]

You can use the technique I showed in http://uk.mathworks.com/matlabcentral/answers/231118#answer_187145 to determine the lengths and pad the shorter entries.

[Azzi Abdelmalek]

In your example, 4368042 doesn't exist in B, and how to will you concatenate A and new_B? They haven't the same number of columns

[Amr Hashem]

4368042 is exist, but the image start from row 6 :)

now i use this code:

 querydevt=alldata2(:,1); 
querymdr=alldata(:,1);
          a1 = cat(1,querydevt{:});
          a2 = cat(1,querymdr{:});
          idx = ismember(a2,a1);  
          idx2 = [alldata(idx,:)];               % all def texts
          idx3 = ismember(a1,a2);
          idx4 = [alldata2(idx3,:)]; 
new_table=[idx4 idx2]

which extract to me matched between A and B in the form

new A

i need to remove the duplicated row

and new B

now i want to form a new table by merge new A and new B

after removing the duplicated row from new A

 new_table=[idx4 idx2]

how i can do this?

[Image Analyst]

Why don't you just attach a .mat file with A and B in it so people can help you much more efficiently and effectively?

[Amr Hashem]

here is the excel sheet, i worked on and the code i write is :

 clear all; clc
tic
[ndata2 text2 alldata2] = xlsread('datecode.xlsx','devtex');
[ndata text alldata] = xlsread('datecode.xlsx','mdr');
[R1,C1]=size(alldata2);
[R2,C2]=size(alldata);
colsize=max(C1,C2);
querydevt=alldata2(:,1); 
querymdr=alldata(:,1);
          a1 = cat(1,querydevt{:});
          a2 = cat(1,querymdr{:});
          idx = ismember(a2,a1);  
          idx2 = [alldata(idx,:)];               % all def texts
          idx3 = ismember(a1,a2);
          idx4 = [alldata2(idx3,:)]; 
new_table=[idx4 idx2]
toc

i want to create a new table contain new A and new B which is new_table=[idx4 idx2]

How i can do this?

[Amr Hashem]

I hope a guy pass from here and provide me with an answer :)

Answer 1

[Amr Hashem]

this code do what I want :

 clear all; clc
tic
[ndata2 text2 alldata2] = xlsread('all.xlsx','all10t14');
[ndata text alldata] = xlsread('mdr1.xlsx','1');
[R1,C1]=size(alldata2);
[R2,C2]=size(alldata);
colsize=max(C1,C2);
querydevt=alldata2(:,1); 
querymdr=alldata(:,1);
          a1 = cat(1,querydevt{:});
          a2 = cat(1,querymdr{:});
          idx = ismember(a2,a1);  
          data1 = [alldata(idx,:)];               % all def texts
          idx3 = ismember(a1,a2);
          data2 = [alldata2(idx3,:)];
 [R3,C3]=size(data1);       % size of data1
[R4,C4]=size(data2);    
data3=cell([R3,C4]);                                  % to rearrange the data3
for i=1:size(data1,1)
    for j=1:length(data1)
        if data1{j,1}==data2{i,1}                % if MDR of all = MDR of event date
            data3(j,:)=data2(i,:);                % save data2 'all'  newfile 'data3'  (56 fields) 
        end
    end
end
match=[data1,data3];
    xlswrite('mdr1.xlsx',idx2,2);
toc

Thanks to you all :)