Sort the rows of a table based on row entries in two columns of another table

I am trying to sort the rows in one table (Tright) based on the order in which the rows are present in another table (Tleft)

Tright ->

   EndNodes_1        EndNodes_2      var1
    __________    __________    _____________    
      {'1' }       {'5' }                   4       
      {'10'}       {'3' }                   1
      {'2' }       {'11'}                   6         
      {'2' }       {'8' }                   2        
      {'3' }       {'14'}                   9 

Tleft ->

   EndNodes_1           EndNodes_2      
    __________          __________    
      {'1' }                {'5' }                         
      {'2' }                {'8'}                           
      {'2' }                {'11' }                      
      {'3' }                {'14'}   
       {'10'}               {'3' }

Expected output:

   T = 
   EndNodes_1            EndNodes_2      var1
    __________           __________    _____________    
      {'1' }                {'5' }                4       
      {'2' }                {'8' }                2        
      {'2' }                {'11'}                6         
      {'3' }                {'14'}                9 
      {'10'}                {'3' }                1

I tried the following,

T = innerjoin(Tleft,Tright)
[~, index] = sort_nat(T.EndNodes_1);
T = T(index,:)

Obtained result:

T ->

   EndNodes_1             EndNodes_2      var1
    __________            __________    _____________    
      {'1' }                {'5' }                   4       
      {'2' }                {'11'}                   6         
      {'2' }                {'8' }                   2        
      {'3' }                {'14'}                   9 
      {'10'}                {'3' }                   1

Any suggestions on how to obtain the expected output will be really helpful.

Code:

ar = {'1' '10' '2' '2' '3'};
br = {'5' '3'  '11' '8' '14'};
cr = [4 1 6 2 9];
Tright = table(ar',br',cr','VariableNames',{'EndNodes_1','EndNodes_2','var1'})

al = {'1' '2' '2' '3' '10'};
bl = {'5' '8'  '11' '14' '3'};
Tleft = table(al',bl','VariableNames',{'EndNodes_1','EndNodes_2'})

T = innerjoin(Tleft,Tright);
[~, index] = sort_nat(T.EndNodes_1);
T = T(index,:)

Answer 1

[Samatha Aleti]

Hi,

According to my understanding you are trying to arrange the table “Tright” columns in the order of table ‘”Tleft”.

You can use “ismember” to do this as follows:

EndNodes_1 = {'1';'10';'2';'2';'3'};  
EndNodes_2 = {'5';'3';'11';'8';'14'};  
var1 = [4; 1; 6; 2; 9];  
Tright = table(EndNodes_1, EndNodes_2, var1)  
t1= table(EndNodes_1, EndNodes_2);  
EndNodes_1 = {'1';'2';'2';'3';'10'};  
EndNodes_2 = {'5';'8';'11'; '14';'3'};  
Tleft = table(EndNodes_1, EndNodes_2)  
t2 = Tleft;  
[Lt2,Loct1] = ismember(t2, t1, 'rows');  
Tright = Tright(Loct1,:)