Combine table variables and assign head-variable name

Hi

I'm trying to concatenate tables together. I have two variables that I combine together in multiple combinations, and each combination can have n solutions. For testing purposes I've kept it short and simple. Right now I have 5 combinations each with 3 solutions.

Using MS Paint magic I've edited the table to look like what I want

I'm pretty sure I've seen a way to do this, but I can't find the page any longer.

Don't worry about 2&3 and 4&5 being identical.

Any help would be appriciated.

[madhan ravi]

upload your tables as .mat files so that the problem is pretty clear

Answer 1

[Walter Roberson]

https://www.mathworks.com/help/matlab/ref/mergevars.html with the Merge as Table option.

Answer 2

[Steven Lord]

t1 = array2table(magic(3), 'VariableNames', {'Col1', 'Col2', 'Col3'})
t2 = array2table(eye(3))
t3 = table(t1, t2, 'VariableNames', {'subtable1', 'subtable2'})
t3.Properties.RowNames = {'huey', 'dewey', 'louie'}

To extract data:

t3{'huey', 'subtable1'}.Col1 % or
t3.subtable1{'huey', 'Col1'}

Answer 3

[Niclas Madsen]

Thank you all!

I'll get this working