How do i eliminate such rows are not common between two tables?

7 Ansichten (letzte 30 Tage)
Dear Experiences...
i have two tables in matlab : fist table involve only 2 columns are : (sample of data)
Country name State name
UK LND
UK BLG
UK SEG
USA WSN
USA NEY
etc...
Second table ... involve details content such following
State name var1 var2 var3 ..... var N
LND
BLG
NEY
etc..
so the output table .. perhaps involve the following
country name State name var 1 ... varN ( but only for the states that are exist in both first and second tables)

Akzeptierte Antwort

Guillaume
Guillaume am 7 Apr. 2017
This is called an inner join
newtable = innerjoin(table1, table2);

Weitere Antworten (0)

Kategorien

Mehr zu Language Fundamentals finden Sie in Help Center und File Exchange

Produkte

Community Treasure Hunt

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

Start Hunting!

Translated by