Clear Filters
Clear Filters

How to store two tables resulting from a for loop

36 views (last 30 days)
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.

Accepted Answer

per isakson
per isakson on 13 Jul 2017
Edited: per isakson on 13 Jul 2017
Yes, with something like this
for jj = 1 : 2
T = something;
filename = sprintf( 'myfile_%d', jj );
writetable( T, filename )
if I understand your question correctly
  1 Comment
Konstantinos Tsitsilonis
Konstantinos Tsitsilonis on 13 Jul 2017
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

Sign in to comment.

More Answers (3)

Elias Gule
Elias Gule on 13 Jul 2017
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;

Elias Gule
Elias Gule on 13 Jul 2017
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
Konstantinos Tsitsilonis on 13 Jul 2017
Edited: Konstantinos Tsitsilonis on 13 Jul 2017
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
Pappu Murthy on 18 May 2018
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.

Sign in to comment.

Jose Rego Terol
Jose Rego Terol on 19 Oct 2019
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)
I got 5 .txt files but my objective is to get 1 .xls file with all the tables (2x5) concatenate vertically
  1 Comment
Daisy on 25 Mar 2022
Hi! Did you ever manage to figure this out? I have the exact same question..

Sign in to comment.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!