How can I create a Lookup Table 5-D?

4 visualizzazioni (ultimi 30 giorni)
Mariana
Mariana il 11 Gen 2020
Risposto: Raunak Gupta il 22 Gen 2020
I have multiple excel files of different dimensions, but same columns (variables)
How can I export this excel files to a lookup table?

Risposte (1)

Raunak Gupta
Raunak Gupta il 22 Gen 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.

Community Treasure Hunt

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

Start Hunting!

Translated by