selecting columns from table
436 views (last 30 days)
Show older comments
hello, i want to create an application which reads the given table and allows user to select columns and then recreating a table with the selected columns.
I am working on forecasting electricity prices and getting data from https://www.epias.com.tr/en/ my code is working on a fixed table template and that is date-hour-price. But some excel files have more than one currency and the table can be date-hour-turkish lira-usd-cad. i want user to be able to choose currency and work on it. reads table and user selects columns (date-hour-try/usd/cad) and creates new table consisted selected columns. My code is https://pastebin.com/UpSYsQrQ. Reading table and formatting is done but. selection callback and confirm push button callbacks are not working properly. it creates a table but table is irrelevant. it's like i can't keep the read data and create an empty one.
0 Comments
Answers (1)
Manas Meena
on 31 May 2021
If you want to pull columns from an existing table and create a new table you can use subscripting.
For example you have a table with 10 columns and you want to pull column 1,2,4 and 9 then you can just use
NumericValueTable(:,[1 2 4 9])
0 Comments
See Also
Categories
Find more on Migrate GUIDE Apps in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!