MATLAB Answers

How can I create a Lookup Table 5-D?

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

  0 Comments

Sign in to comment.

Answers (1)

Raunak Gupta
Raunak Gupta on 22 Jan 2020 at 9:28
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 Comments

Sign in to comment.

Sign in to answer this question.