Compare two tables and extract data
显示 更早的评论
Hello, I have two data matrix: A and B
A =
101 62
102 65
103 62
104 58
105 72
106 80
B =
99 65
100 62
102 80
104 71
105 73
109 62
I would like to search all same values in first column of A and B, and create a column C with all the extracted rows from A and B :
C =
102 65 80
104 58 71
105 72 73
Any help is very much appreciated!
采纳的回答
Ameer Hamza
2020-10-12
编辑：Ameer Hamza
2020-10-12
Try this
A = [
101 62
102 65
103 62
104 58
105 72
106 80];
B = [
99 65
100 62
102 80
104 71
105 73
109 62];
[idxA, idxB] = ismember(A(:,1), B(:,1));
C = [A(idxA, :) B(idxB(idxB~=0), 2)];
4 个评论
MELO
2020-10-12
Ameer Hamza
2020-10-12
I am glad to be of help!!!
MELO
2020-10-13
Ameer Hamza
2020-10-13
My pleasure! You may accept the answer to show appreciation.
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Logical 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
