Clear Filters
Clear Filters

How can I create a Lookup Table 5-D?

5 views (last 30 days)
Mariana
Mariana on 11 Jan 2020
Answered: Raunak Gupta on 22 Jan 2020
I have multiple excel files of different dimensions, but same columns (variables)
How can I export this excel files to a lookup table?

Answers (1)

Raunak Gupta
Raunak Gupta on 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.

Community Treasure Hunt

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

Start Hunting!