assigning nested for loop value to matrix.

Hi guys i have a list of 41 names called N. I also have a cell called output.

'output' is a 375x1 cell. each cell is a table:

output:
4x3 table
3x3 table
196x3 table
1x3 table
100x3 table
....

each table has 3columns(Patient, number,Name)

Table1:
patient   number  Name
1	     112	    Name1
1	     206	   Name1
1	     212	   Name2
1	     112	   Name3 
Table2:
patient   number  Name
2	     11	    Name15
2	     20	   Name10
2	     33	   Name2
....

I also have a list of refrence Names: N=Name1,Name2,Name3,....

I need to look at each cell and see if it has Name1. Then if it does look the colunm 'number' and find the minmun number. Then repeat the same porecess for the 41 Names per cell. so the result should be a 357X41 array. each column representing the names and each row representing each cell.

this is what i have so far but no matter how many versions i try to assign the values to an array or matrix. I cant seem to get it right! I would appriciate any help. lmk if there are any questions.

Thank you in advance!

b4=zeros(357,41); 
for i=1:length(output) % for each cell
    for j=1:length(N) %for each name
        b=(output{i,1}.name==N(j)); %for i:here looking at table within each cell. then looking at column 'name'. for j:going overlist of names and calling each name
        b1=(output{i,1}.number); %here looking at table within each cell. then looking at column 'number'
        b2=(b1(b)); %finding columns in 'number' that are assosiated with the name i am looking for 
        b3=min(b2);%finding the minimun value of the column 'number' that matched the name i wanted 
        b4(i,j)=b3 %asign value to matrix
end 

Answer 1

[Bhargavi Maganuru]

Line 4 in your code gives logical matrix and using it in Line6 gives error.

You can modify your code as

b4=zeros(357,41);  
for i=1:length(output) % for each cell 
    for j=1:length(N) %for each name 
        b=(output{i,1}.name==N(j)); %for i:here looking at table within each cell. then looking at column 'name'. for j:going overlist of names and calling each name 
        if( nnz(b(:,5))~=0)   %if N(j) is present,then find the minimum number corresponding to N(j) 
            b1=(output{i,1}.number); %here looking at table within each cell. then looking at column 'number' 
            b2=(b1(b(:,5)); %finding columns in 'number' that are assosiated with the name i am looking for  
            b3=min(b2);%finding the minimun value of the column 'number' that matched the name i wanted  
            b4(i,j)=b3 ;%asign value to matrix 
        end 
    end 
end 

Hope this helps!

[ALDO]

Thank you so much for taking the time to look over this! This helped me immensely:)