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

Question

ahmed obaid 2017-6-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/343893-how-do-i-sort-table-rows-based-on-other-table-rows

回答： 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

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Andrei Bobrov 2017-6-8

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/343893-how-do-i-sort-table-rows-based-on-other-table-rows#answer_270032

在 MATLAB Online 中打开

[~,ii] = ismember(A.num,B.num);
B_sorted_as_A = B(ii,:);

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

Guillaume 2017-6-8

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/343893-how-do-i-sort-table-rows-based-on-other-table-rows#answer_270029

在 MATLAB Online 中打开

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, :);