Copy data for one table to another

조회 수: 18 (최근 30일)
Juan Martinez
Juan Martinez 2018년 7월 29일
편집: Stephen23 2018년 7월 30일
Hi all, i am working with tables and i have one problem. I have one table:
This table have unique sort index values (1,2,3...) and the values in second column that i want copy.
The other table that i want to paste the values with his index is:
The result would be:
How i can make this? I am trying to have some indexing such as:
if true
B.coefic = [B A(B,2)];
end
But wrong results.
Thank you very much!

채택된 답변

Stephen23
Stephen23 2018년 7월 30일
편집: Stephen23 2018년 7월 30일
[~,idx] = ismember(B.Fecha,A.Fecha);
B.coeff = A.values1(idx)
Or
B = A(idx,:)
Demonstrated using numeric arrays:
>> A = [1,2,3,4,5,6,7;15,12,18,11,19,10,14].'
A =
1 15
2 12
3 18
4 11
5 19
6 10
7 14
>> B = [1,1,1,2,2,3,3,3,4,5,5,6,7].'
B =
1
1
1
2
2
3
3
3
4
5
5
6
7
>> [~,idx] = ismember(B,A(:,1));
>> A(idx,:)
ans =
1 15
1 15
1 15
2 12
2 12
3 18
3 18
3 18
4 11
5 19
5 19
6 10
7 14

추가 답변 (0개)

카테고리

Help CenterFile Exchange에서 Tables에 대해 자세히 알아보기

태그

제품


릴리스

R2015b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by