Unable to concatenate tables

Hi,

I am new to Matlab. I use Matlab R2018b.

I have 2 tables (t1 and t2), first one is the size of 931x7, and the other one is 1x7. I want to concatenate them (later I will write it to Excel file).

I tried two ways:

t1 = [t1;t2];
t1 = cat(1,t1,t2);

None of them works, both gave me "Error using vertcat. Dimensions of arrays being concatenated are not consistent".

What did I do wrong?

Answer 1

[Image Analyst]

You can't have both numbers and characters in the same column, which is what you were trying to do. This works:

colHeaderExcel = {'Time_hour','Speed_ms_per_sec', ...
    'LevelTime_hour','Level', ...
    'Entries','TotalItem','BypassItem'};
reportMatrix = rand(9, 7);
t1 = array2table(reportMatrix,'VariableNames',colHeaderExcel);
t2(1,1).Time_hour = 0 ; '\nStatistics:\n\nAverage Write: xx\nAverate Read: yy\n';
t2(1,1).Speed_ms_per_sec = 0;
t2(1,1).LevelTime_hour = 0;
t2(1,1).Level = 0;
t2(1,1).Entries = 0;
t2(1,1).TotalItem = 0;
t2(1,1).BypassItem = 0;
t2 = struct2table(t2)
t2.Properties.VariableNames = t1.Properties.VariableNames;
t3 = [t1; t2]
t4 = cat(1,t1,t2) % Alternate operation

[SereneGuy]

Ah I see, thank you so much. Here is the thing, I tried to add statistics report at the bottom of the Excel, which are lines of mixed characters and numbers. So, t2 is this statistics reports, while t1 are the data. So, I tried to append t2 to t1, and then write t1 to Excel file.

excelFilename = 'C:\temp\report.xls';
writetable(t1,excelFilename);

I believe I didn't choose the right method to achieve this. What can I do other than appending t2 to t1?

What will be the best way to append lines of texts (mixed of characters and numbers) at the bottom of Excel spreadsheet?

[Image Analyst]

If you want a single column to have both characters and numbers, you'll need to use a cell array, not a matrix or a table. Then use writecell(ca, filename) to write the cell array to the file.

https://matlab.fandom.com/wiki/FAQ#What_is_a_cell_array?

[SereneGuy]

Thank you so much!

[SereneGuy]

@Walter Roberson Btw, sorry to unaccept the answer. I just tried it, I still see the warning, unfortunately. Any other idea? Or did I miss something?