How to section a matrix?

2017 11 17
1 个回答
更新时间：2017 11 20
1 次查看（30 天）

0 个投票

I am trying to retrieve the latest date entry formation from a table. I have changes the date to a serial number and created a separate matrix with equipment_id and serial number. There are multiple serial numbers for the equipment_id, but just need the highest serial number, since is is the date date entry.
* euip_id serial number.
* -9999866 730537
* -9999866 733865
* -9999747 731652
* -9999747 732028
* -9999747 729692
* -9999747 735361

请先登录，再回答此问题。

回答（1 个）

M
M 2017-11-20
编辑：M 2017-11-20

0 个投票

Maybe using something like this :
M=[-9999866 730537;
-999986 733865;
-9999747 731652;
-9999747 732028;
-9999747 729692;
-9999747 735361];
id=-9999747; % choose an id
indices where first row of M is equal to the desired id :
index=M(:,1)==id;
index =
6×1 logical array
0
0
1
1
1
1
And take the maximum of the corresponding serial number
max(M(index,2))
ans =
735361

类别

在 帮助中心 和 File Exchange 中查找有关 Resizing and Reshaping Matrices 的更多信息

标签

编辑：

M
M
2017-11-20

Community Treasure Hunt

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

Start Hunting!

Translated by