Combining many variables into one table
3 views (last 30 days)
Show older comments
I have 100 variables from simulink output all stored in a huge .mat file (after being collated from seperated .mat files). I just want a specific variable from each one in a table. The examples of making a table have a few variables in that you type the names manually to create the table.
T = table (results(1, 1).Collision1.signals.values, results(2, 1).Collision1.signals.values,results(3, 1).Collision1.signals.values, results(4, 1).Collision1.signals.values
I will have 300 so this isnt an option.
How can I get the specific variable out I want :
results(1, 1).Collision1.signals.values
results(2, 1).Collision1.signals.values
results(3, 1).Collision1.signals.values
******
results(99, 1).Collision1.signals.values
results(100, 1).Collision1.signals.values
and plot them all in one table?
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/921809/image.png)
(figure 1, variables from .mat resullts workspace)
Many thanks
Erin
0 Comments
Answers (2)
Benjamin Thompson
on 10 Mar 2022
You can use addvars in a for loop to successively add columns to a table. Note all table columns will need to have the same number of entries. I am guessing at variable names here but if you have further questions post sample data.
T = table();
for i = 1:N
T = addvars(T, results(i, 1).Collision1.signals.values,['results(' num2str(i) ', 1).Collision1.signals.values']);
end
4 Comments
Peter Perkins
on 11 Mar 2022
This will probably work, but will create some pretty awkward variable names. I suggest something more like ['X' num2str(i)]. Also, addvars is fine, but
T.(['X' num2str(i)]) = results(i, 1).Collision1.signals.values
might be easier to read.
Peter Perkins
on 11 Mar 2022
In recent MATLAB version, there's Simulink.Simulation.Dataset called extractTimetable. Not sure if that's what you have, but it might help.
0 Comments
See Also
Categories
Find more on Logical in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!