Latest Date Entry Record

8 次查看（过去 30 天）

Faustino Quintanilla 2017-11-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/368657-latest-date-entry-record

回答： Faustino Quintanilla 2017-11-27

I have a large data set that contains multiple tests for the same pieces of equipment over many years. How can I isolate the latest test results only for the various pieces of equipment? There is a date stamp and equipment id and test results.

For example, for motor X, what are the last or current oil reports and ignore previous old test.

2 个评论
显示无隐藏无

KL 2017-11-22

how do you store your data?

Faustino Quintanilla 2017-11-22

I have the information in a table. The table is updated daily with new test information.

请先登录，再进行评论。

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

采纳的回答

KL 2017-11-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/368657-latest-date-entry-record#answer_292641

在 MATLAB Online 中打开

use sortrows,

https://de.mathworks.com/help/matlab/ref/sortrows.html#bt8bz9j-2

sortedTable = sortrows(yourTable,'timestampColumnName')

6 个评论
显示 4更早的评论隐藏 4更早的评论

Faustino Quintanilla 2017-11-27

在 MATLAB Online 中打开

Here is the code used. Where do I add the T1(end,:)?

for x=1:height(sortedTable)
    T1 = sortrows(sortedTable(sortedTable.position_id==x,:),'sampledt_MAIN');
end

KL 2017-11-27

在 MATLAB Online 中打开

Alright, you're extracting it for all equipments, so

 T_latest = table;
 for x=1:height(sortedTable)
    T1 = sortrows(sortedTable(sortedTable.position_id==x,:),'sampledt_MAIN');
    T_latest = [T_latest; T1(end,:)];
 end