Database toolbox downloading individual data as cell arrays

2 views (last 30 days)
Hi, I am using database toolbox to fetch data using MySql. However the fetched data matrix consists of individual values as cell arrays. How can I download the data as a matrix consisting as simple values? I simply want to download the entire table as a simple matrix. Thanks.

Answers (2)

Guillaume
Guillaume on 20 Jul 2016
I don't have the database toolbox but I assume it returns the contents of a table as a cell array because there is no guarantee that the columns are numeric and never empty.
If you are sure that the columns are always numeric and never empty, then:
dataasmatrix = cell2mat(yourfetcheddata)

Azura Hashim
Azura Hashim on 22 Jul 2016
Excellent, this works. Thanks for your help.

Products

Community Treasure Hunt

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

Start Hunting!