Trouble concatenating two tables
조회 수: 4 (최근 30일)
이전 댓글 표시
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?
댓글 수: 0
답변 (3개)
Star Strider
2017년 4월 21일
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.
댓글 수: 2
Star Strider
2017년 4월 24일
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.
Gabor
2021년 5월 20일
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))
댓글 수: 0
Pufang Yan
2022년 4월 1일
the columns of 2 tables have different value types. one is numeric, the other is text.
댓글 수: 0
참고 항목
카테고리
Help Center 및 File Exchange에서 Logical에 대해 자세히 알아보기
제품
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!