MATLAB: Get value from table/matrix based on common attribute

common attributeextractMATLABtable

I have two tables, A with informtions about people and where they live, B informations about cities. Several people can live in the same city. How can I add columns in A with the informations in B (city name, country) based on the Citycode without a loop?
A = table('Name','First','Citycode')
B = table('Citycode','CityName','Country')
A = ['Smith' 'John' '1001';
    'Taylor' 'James' '1004';
    'Thatcher' 'Mary' '1001']
B = ['1001' 'New York' 'USA';
    '1002' 'London' 'UK';
    '1004' 'Madrid' 'Spain']

Best Answer

% input data
A = {'Smith' 'John' '1001';
    'Taylor' 'James' '1004';
    'Thatcher' 'Mary' '1001'};
B = {'1001' 'New York' 'USA';
    '1002' 'London' 'UK';
    '1004' 'Madrid' 'Spain'};
A_t = cell2table(A,'VariableNames',{'Name','First','Citycode'});
B_t = cell2table(B,'VariableNames',{'Citycode','CityName','Country'});
% join
T = innerjoin(A_t,B_t)
T =
3×5 table
Name First Citycode CityName Country
____________ _________ ________ ____________ _________
{'Smith' } {'John' } {'1001'} {'New York'} {'USA' }
{'Thatcher'} {'Mary' } {'1001'} {'New York'} {'USA' }
{'Taylor' } {'James'} {'1004'} {'Madrid' } {'Spain'}
Related Question