datasheet = [1 2 3 4; 5 6 7 8; 9 10 11 12; 13 14 15 16] // Datasheet (rows: 4, Columns: 4)
Now creating Column Vectors based on above datasheet
A = [1; 5; 9; 13]
B = [2; 6; 10; 14]
C = [3; 7; 11; 15]
D = [4; 8; 12; 16]
Creating new column Vectors from above vectors based on few constraints
A1 = [1; 9]
PA1 = [1; 3] //position vector of A1 from A
B1 = [6; 10; 14]
PB1 = [2; 3; 4] //position vector of B1 from B
C1 = [7; 11]
PC1 = [2; 3] //position vector of C1 from C
D1 = [4; 12]
PD1 = [1; 3] //position vector of D1 from D
FILTERED DATASHEET
F_datasheet = [9 10 11 12] // As you can see the datasheet is filtered based on the above position vectors.
My Objective:
How to get a filtered datasheet which includes ONLY those rows where PA1, PB1, PC1, PD1 have common values (i.e. here its only 3)?