select/save part of database into another database
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
addy fang
le 17 Juil 2020
Commenté : addy fang
le 19 Juil 2020
I have database A of four columns: a, b, c, d, and want to save those rows of d values of less than -10 into another database B. How can I do it?
2 commentaires
Réponse acceptée
Mohammad Sami
le 17 Juil 2020
I assume you are able to read the excel directly using the readtable function.
% excelfilepath = 'C:\...';
% DBA = readtable(excelfilepath);
DBB = DBA(DBA.d < -10,:);
% exceloutpath = 'C:\....';
% writetable(DBB,exceloutpath);
3 commentaires
Mohammad Sami
le 17 Juil 2020
"2" in y.2 is not a valid vairable or column name. If y is a table see what is the column name.
If y is a matrix, use
z1=y(y(:,2)<-10, :);
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Database Toolbox dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!