different excel file comparisons

Hello, I have two excel files,
First excel file as shown below
and second excel file as shown below.
I want to compare these excel files values but ı have a problem. As you seen in the first column the order of the names are not same. How can I compare these two excel file among the same names.I will print the results on the adjacent column after the comparison.

Antworten (1)

KSSV
KSSV am 19 Apr. 2021

1 Stimme

T1 = readtable(file1) ;
T2 = readtable(file2) ;
idx = ismember(T1.names, T2.names)

1 Kommentar

Lütfü Emre Efe
Lütfü Emre Efe am 19 Apr. 2021
Thank you. I also want to compare their values by sorting the names.

Melden Sie sich an, um zu kommentieren.

Kategorien

Produkte

Gefragt:

am 19 Apr. 2021

Kommentiert:

am 19 Apr. 2021

Community Treasure Hunt

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

Start Hunting!

Translated by