MATLAB Answers

How to store two tables resulting from a for loop

71 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 )
end
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
y(i)=i+2
end

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;
end

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);
  2 Comments
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
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!

Community Treasure Hunt

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

Start Hunting!