MATLAB Answers

How to Filter Datasheet

4 views (last 30 days)
Jasraj Soni on 8 Sep 2019
Answered: Neuropragmatist on 9 Sep 2019
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)?
0 CommentsShowHide -1 older comments

Sign in to comment.

Answers (1)

Neuropragmatist on 9 Sep 2019
Why do you want to do this?
Its certinaly poossible to write code to do what you want, I'm just wondering if maybe there is a more efficient way to do what you ultimately want...
M.
0 CommentsShowHide -1 older comments

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!

Translated by