Determine value in the 3rd column of a matrix based on the first and second column values
3 views (last 30 days)
Show older comments
Lars Meijer
on 12 Jan 2024
Commented: Dyuman Joshi
on 15 Jan 2024
I have a matrix, say like this:
M = [3 2 10; 4 3 4; 3 1 3; 2 1 12; 2 2 10; 4 1 18; 4 2 12];
Where the order is like this: [job, machine, production_time]
So based on the job and the machine the job should be on, I want to deduce the production time on it.
I can not seem to find anything that can do this for me. Any help is appreciated!
0 Comments
Accepted Answer
Dyuman Joshi
on 12 Jan 2024
Edited: Dyuman Joshi
on 12 Jan 2024
M = [3 2 10; 4 3 4; 3 1 3; 2 1 12; 2 2 10; 4 1 18; 4 2 12];
job = 3;
machine = 2;
idx = ismember(M(:,1:2), [job machine], 'rows')
out = M(idx, 3)
If job and machine contain multiple values, compare them individually and use those indices to get the corresponding values as per requirement.
3 Comments
More Answers (0)
See Also
Categories
Find more on Startup and Shutdown in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!