Copy data for one table to another

25 ビュー (過去 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 Center および File ExchangeTables についてさらに検索

タグ

製品


リリース

R2015b

Community Treasure Hunt

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

Start Hunting!

Translated by