Latest Date Entry Record
8 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Faustino Quintanilla
il 22 Nov 2017
Risposto: Faustino Quintanilla
il 27 Nov 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 Commenti
Risposta accettata
KL
il 22 Nov 2017
use sortrows,
sortedTable = sortrows(yourTable,'timestampColumnName')
6 Commenti
KL
il 27 Nov 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.
Più risposte (1)
Vedere anche
Categorie
Scopri di più su Data Types in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!