Azzera filtri
Azzera filtri

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

2 visualizzazioni (ultimi 30 giorni)
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)

Risposta accettata

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

Più risposte (0)

Categorie

Scopri di più su MATLAB in Help Center e File Exchange

Prodotti

Community Treasure Hunt

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

Start Hunting!

Translated by