select/save part of database into another database
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
addy fang
il 17 Lug 2020
Commentato: addy fang
il 19 Lug 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 Commenti
Risposta accettata
Mohammad Sami
il 17 Lug 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 Commenti
Mohammad Sami
il 17 Lug 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, :);
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Database Toolbox 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!