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

How to access the specific value in table according to the input parameters?

1 次查看（过去 30 天）
Konstantin Tkachuk
Konstantin Tkachuk 2019-2-20
评论： Konstantin Tkachuk 2019-2-20
I am working with SQL database and convert it to matlab table using
results = fetch(conn,sqlquery);
LCA_Database = cell2table(results);
LCA_Database looks like this:
LCA_Database1.JPG
LCA_Database2.JPG
My question is how can I access the data stored in for example 11 column pentr according to the input parameters: Name == 'Construction Steel' and lca_phase == 'D' ?
I cannot change the rows and columns as all database is structured like that. AS well I cannot assign the rownames to the name of material as it remains the same for 5 rows and matlab do not allow me to do that.
Can I create new table out of this table with automatic assignment of rownames that will contain name of the material + lca_phase?

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

采纳的回答

madhan ravi
madhan ravi 2019-2-20
LCA_Database(contains(LCA_Database.Name,'Construction Steel')&contains(LCA_Database.lca_phase,'D'),:)

更多回答（0 个）

类别

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

标签

产品


版本

R2017b

Community Treasure Hunt

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

Start Hunting!

Translated by