- Details
- Parent Category: Programming Assignments' Solutions
We Helped With This MATLAB Programming Assignment: Have A Similar One?
SOLVED

Short Assignment Requirements
Hi,I am attempting to create a data analysis tool in app designer. I have an issue whereby I am trying to filter the table based on the values in the table. For example, I am importing a file called Journals Copy and in the panel 'filter', there is a drop down which automatically items itself based on the column headers of the imported table. I would like for the table to show rows based on the dropdown and the edit field. As such, all document types (drop down value) where the cell inside document type is GJ (edit field text). Then by pushing the button, it would filter the table based on those criteria. So far I have the below code for the button function:
app.FinalTable = strcmp(app.UITable.Data.(app.FilterDD),(app.JEditValue));
app.UITable.Data = app.FinalTable;However, this ticks all the rows that meets the criteria and does not show the rows on table.The tool is nearly completed but this portion of the application has had me clueless for days.Many Thanks
Assignment Image
![MATLAB Assignment Description Image [Solution]](/images_solved/0833016/1/im.webp)
File Help
Analysis
Fields
Journal ID
Plot Statistics
>
S
S▬▬▬
Filter
DocumentType
GJ
Filter
Balance Verification
CompanyCode
Fields
UI Figure
Sum
CompanyCode DocumentNumber DocumentType Fiscal Year
Control Total
0
Field 2
Summary
Field 1 Company Code
CompanyCode
FiscalPeriod Username
I
Summarise
0
Description Amount
X
Assignment Image
![MATLAB Assignment Description Image [Solution]](/images_solved/0833016/2/im.webp)
File Help
Analysis
Plot
Fields
Journal ID
1000
1000
1000
1000
1000
1000
1000
1000
1000
1000
1000
1000
Statistics
Filter
DocumentType
GJ
Filter
CompanyCode DocumentNumber DocumentType
1000 SL
2000 PL
5000 GJ
3500 PL
7000 GJ
2090 SL
9270 GJ
6780 OE
2930 GJ
4370 OE
8380 OE
10000 SL
Fields
Balance Verification
Sum
UI Figure
CompanyCode▾
Control Total
Fiscal Year
2018
2018
2018
2018
2018
2018
2018
2018
2018
2018
2018
2018
0
5 BLIN
6 OTWA
7 JBRIGGS
8 OTWA
9 LDON
Field 1
FiscalPeriod Username
1 NYORK
2 OTWA
3 LDON
4 NYORK
10 BLIN
11 NYORK
12 BLIN
Field 2
Summary
Company Code
Company Code
Summarise
Description
Sales Ledger
Purchase L...
Nominal Le...
Purchase L...
Nominal Le...
Sales Ledger
Nominal Le...
Other Expe...
Nominal Le...
Other Expe...
Other Expe...
Sales Ledger
Amount
X
3750
284.8200
-5.1235e+03
4.7298e+03
-9.8205e+03
1.7384e+03
5.1235e+03
849.2800
9.8205e+03
-4.8528e+03
-726.8400
400