How do i sort table rows based on other table rows ?

18 次查看（过去 30 天）
ahmed obaid
ahmed obaid 2017-6-8
回答： Andrei Bobrov 2017-6-8
Dear experiences..
i have two tables.. A and B..
where table A involves ( id, num, var1 , var2).., and table B involves (num, var1.....varn).. i need to sort either table A rows based on table B num order or vise versa... how do i perform this task ?
thanks

请先登录，再回答此问题。

采纳的回答

Andrei Bobrov
Andrei Bobrov 2017-6-8
[~,ii] = ismember(A.num,B.num);
B_sorted_as_A = B(ii,:);

更多回答（1 个）

Guillaume
Guillaume 2017-6-8
sorting A according to B:
[isinB, whereinB] = ismember(tableA.num, tableN.num);
assert(all(isinB), 'some rows of A are not found in B);
[~, order] = sort(whereinB);
sortedtableA = tableA(order, :);

类别

在 Help Center 和 File Exchange 中查找有关 Tables 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by