Info

此问题已关闭。 请重新打开它进行编辑或回答。

How do i joine many tables that exist in excel files using matlab?

1 次查看（过去 30 天）
ahmed obaid
ahmed obaid 2017-5-25
关闭： MATLAB Answer Bot 2021-8-20
Dear experiences..
i have many excel files that stored in D:\table directory, all excel files involves unique headers ( file name , label) and look like the following:
file name label
steer-20-30 1
agilty-come-tone 2
reed-20-20-3 1
etc..
in all files, file name column is unique also but in every file its come in different orders than others based on label values, i need to join all these files to be in general table.. look like the following:
file name label1_(max value in label field=2) label2_(max value in label field=4)....
steer-20-30 1 3
agilty-come-tone 2 4
reed-20-20-3 1 2
etc..
where:
label1 field its come from excel file1, label2 field comes from excel file2, label3 field comes from excel file3...etc, labels columns perhabs comes with (label) header and concatenated with max values in every label columns .. example (label_2), (label_4), ...etc. example of two tables...
thanks for any help.

此问题已关闭。

回答（1 个）

MathReallyWorks
MathReallyWorks 2017-5-25
Hello Ahmed,
Why this question again?
For other people, who have visited here for first time:
Check out Guillaume's solution on a similar question: how do i combine multible excel file into single file using matlab?
  1 个评论
ahmed obaid
ahmed obaid 2017-5-25
thanks, for your comments, in my previous question i need to combine files without joining property... here join among tables must be perfomed on columns .. there based on whatever data exist , thanks

此问题已关闭。

标签

Community Treasure Hunt

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

Start Hunting!

Translated by