清空筛选条件
清空筛选条件

select/save part of database into another database

1 次查看（过去 30 天）
addy fang
addy fang 2020-7-17
评论： addy fang 2020-7-19
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 个评论
Mohammad Sami
Mohammad Sami 2020-7-17
Did you mean a Matlab table or matrix or an SQL Database ?
addy fang
addy fang 2020-7-17
编辑：addy fang 2020-7-17
It is an Excel table, can be read in to a Matlab matrix. For example, the first column is the name, second is address, third is height, and forth column is weight loss. I need to retable those with certain weight loss, less then -10 lbs.

请先登录，再进行评论。

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

采纳的回答

Mohammad Sami
Mohammad Sami 2020-7-17
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 个评论
显示 1更早的评论
Mohammad Sami
Mohammad Sami 2020-7-17
"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, :);

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by