Storing data in Table inside for loop
Afficher commentaires plus anciens
I wish to create a table where one row will be added in each for loop iteration. The caclulation is correct, but I cannot store them in a table. Can I get any suggestions?
clc
clear
raw=readtable('Small.xlsx');
model=readtable('Models.xlsx');
problem=readtable('Problems.xlsx');
raw_model=raw.Models;
raw_problem=raw.Problems;
M=height(model);
P=height(problem);
for j=1:1:M
reference1=model{j,1};
A = raw(strcmp(raw_model,reference1),2);
for i=1:1:P
reference2=problem{i,1};
B = A(strcmp(A{:,1},reference2),1);
quantity=height(B);
C = [reference1,reference2,quantity]
T(i,:)=table(C)
%above line is re-written in each iteration. I wish to store data C for all iteration
end
end
Réponse acceptée
Plus de réponses (0)
Catégories
En savoir plus sur Multidimensional Arrays dans Centre d'aide et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!