How do i sort table rows based on other table rows ?
15 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
ahmed obaid
am 8 Jun. 2017
Beantwortet: Andrei Bobrov
am 8 Jun. 2017
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 Kommentare
Akzeptierte Antwort
Weitere Antworten (1)
Guillaume
am 8 Jun. 2017
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, :);
0 Kommentare
Siehe auch
Kategorien
Mehr zu Shifting and Sorting Matrices finden Sie in Help Center und File Exchange
Produkte
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!