How can I create a Lookup Table 5-D?
3 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
I have multiple excel files of different dimensions, but same columns (variables)
How can I export this excel files to a lookup table?
0 Kommentare
Antworten (1)
Raunak Gupta
am 22 Jan. 2020
Hi,
I assume by having same variables in all the excel files, the different dimensions that is mentioned in the question represent different number of rows present in those excel files. I suggest appending all the excel files into a single table by reading each excel file one by one and adding it to the table. For reading one excel file into a table you may use readtable. For joining two table you may use following
table_1 = readtable(filename_excel_1);
table_2 = readtable(filename_excel_2);
new_table = [table_1; table_2];
For creating a lookup table, I assume you want value of a single variable which have dependency on all other remaining variable. For this part you may find this Answer useful and you can use interpn for creating the lookup table.
0 Kommentare
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!