Determine value in the 3rd column of a matrix based on the first and second column values
2 次查看(过去 30 天)
显示 更早的评论
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 个评论
采纳的回答
Dyuman Joshi
2024-1-12
编辑:Dyuman Joshi
2024-1-12
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 个评论
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Startup and Shutdown 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!