How to store two tables resulting from a for loop

Hi guys,

I have a for loop with two iterations, and each iteration results into a table.

I would like to know whether it is possible to store the two tables coming out of the for loop such that I do not get the table from the first iteration overwritten from the second one.

Thanks for your help in advance.

Answer 1

[per isakson]

Yes, with something like this

for jj = 1 : 2
    T = something;
    filename = sprintf( 'myfile_%d', jj );
    writetable( T, filename )
end

if I understand your question correctly

[Konstantinos Tsitsilonis]

Yes, that essentially what I want. Is there a way to 'save' the results without actually saving a .txt file? Like the same way you would do it in a vector:

 for i=1:2
   y(i)=i+2
 end

Answer 2

[Elias Gule]

Ok, I now understand what you want.

numIters = 3;
tables   = cell(numIters,1); % A cell array to store the tables
for index = 1 : numIters
    t0 = table(); 
    tables{index} = t0;
end

[Konstantinos Tsitsilonis]

Indeed, that is exactly what i wanted. Thanks a lot

Answer 3

[Elias Gule]

Try this.

t1   = table();
t1.Name = 'My Name';
t1.Age  = 89;
data = table();
data.Name = 'Your Name';
data.Age  = 15;
% Append data contained in the t1 table to the data table
data = vertcat(data,t1);

[Konstantinos Tsitsilonis]

Thanks for your answer Elias.

This approach shows how to store results from a for loop in one table if I understand correctly.

However, my problem is that I want each iteration to store its results in separate tables. I.e. if the for loop has 3 iterations, there should be three output tables, etc.

[Pappu Murthy]

the statement "data = vertcat(data,t1); produced and error. Could not concatenate the table variable 'Name' using VERTCAT.

Caused by: Error using vertcat Dimensions of arrays being concatenated are not consistent.

Answer 4

[Jose Rego Terol]

Hi!

This thread is being very useful but I cannot find the way to save my tables in a excel file.

Here is the code

for jj = 1 : length(theFiles)
    Table_parameters_spike = table(T,Q_spike,I_max,AT_HW,AT_RT)
    filename = sprintf( 'Spike_%d', jj );
    writetable(Table_parameters_spike, filename)
end

I got 5 .txt files but my objective is to get 1 .xls file with all the tables (2x5) concatenate vertically

Thanks!

[Daisy]

Hi! Did you ever manage to figure this out? I have the exact same question..