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.

Réponses (1)

KSSV
KSSV le 19 Avr 2021
T1 = readtable(file1) ;
T2 = readtable(file2) ;
idx = ismember(T1.names, T2.names)

1 commentaire

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

Connectez-vous pour commenter.

Catégories

Produits

Community Treasure Hunt

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

Start Hunting!

Translated by