Trouble concatenating two tables

Hello, I am having some issues concatenating two tables. When I try, i get the error "Cannot concatenate the table variable 'Header_Name' because it is a cell in one table and a non-cell in another." I believe this is because in one table the contents of this column are all numbers while in another they have letters. When I look at them, the one with letters has apostrophes around them while the one with numbers doesn't. Can anyone help me with this?

Answer 1

[Star Strider]

It will likely be easier to convert the numbers to a cell array of strings.

Something like this will work:

numbers = randi(9, 10, 1);
num_str = num2str(numbers);
num_cell = mat2cell(num_str, ones(10, 1), 1);

Those could probably be combined into a single line. I left them separate to demonstrate how the code works.

Experiment with your table entries to get the result you want.

[Ryan Callahan]

My issue with this seems to be that the tables are combinations of cells with numbers and cells with both letters and numbers. So num2str does not seem to work

[Star Strider]

My idea is to to convert only the numbers to a cell array of strings, then put them into your table in place of the numbers, leaving your existing cell array of strings unchanged.

Your table then contains only a cell array of strings.

Answer 2

[Gabor]

I would add to check the missmatching table variables by comparing them by for eg.:

class(Table1.Column_name(1))

class(Table2.Column_name(1))

Answer 3

[Pufang Yan]

the columns of 2 tables have different value types. one is numeric, the other is text.