How to section a matrix?
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
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
0 comentarios
Respuestas (1)
M
el 20 de Nov. de 2017
Editada: M
el 20 de Nov. de 2017
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
0 comentarios
Ver también
Categorías
Más información sobre Resizing and Reshaping Matrices en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!