How can I create a Lookup Table 5-D?
11 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I have multiple excel files of different dimensions, but same columns (variables)
How can I export this excel files to a lookup table?
0 commentaires
Réponses (1)
Raunak Gupta
le 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 commentaires
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!