Latest Date Entry Record
8 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Faustino Quintanilla
el 22 de Nov. de 2017
Respondida: Faustino Quintanilla
el 27 de Nov. de 2017
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 comentarios
Respuesta aceptada
KL
el 22 de Nov. de 2017
use sortrows,
sortedTable = sortrows(yourTable,'timestampColumnName')
6 comentarios
KL
el 27 de Nov. de 2017
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
now, T_latest should have the last entries corresponding to all x.
Más respuestas (1)
Ver también
Categorías
Más información sobre Data Types 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!