How to section a matrix?
조회 수: 1 (최근 30일)
이전 댓글 표시
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
답변 (1개)
M
2017년 11월 20일
편집: M
2017년 11월 20일
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
참고 항목
카테고리
Help Center 및 File Exchange에서 Resizing and Reshaping Matrices에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!