Display value from one table next to a certain name in another table

I have a very long data set with two tables that I'm going to give shortened examples of to explain what I'm trying to do. In Table 1 I have the following names:

'AAA'
'BBB'
'CCC'

and the following values corresponding to each of these members:

834240000
9951600
2383500

In another, longer table I have more names, some of which are found in table 1 but not all. For example:

'GGG'
'ZZZ'
'MMM'
'AAA'
'QQQ'
'FFF'
'BBB'
'YYY'

I want to display the value of each name in table 1 next to the matching name in table 2 but I'm having trouble doing that because of the different number of rows. I'd really appreciate some help!

[dpb]

Attach a sample (small) set of tables for folks to play with...

[Adam Danz]

Sounds like you're looking for a vlookup which is just a matter of indexing and strcmp or ismember in Matlab.

Answer 1

[Iuliu Ardelean]

Hi,

I'm assuming your variables will look like this:

names_1 = ['AAA'; 'BBB'; 'CCC'];
values_1 = [834240000; 9951600; 2383500];

names_2 = ['GGG'; 'ZZZ'; 'MMM'; 'AAA'; 'QQQ'; 'FFF'; 'BBB'; 'YYY'];
values_2 = zeros(length(names_2), 1); % initialize values_2 as column of zeros for now

% find which members in names_2 also appear in names_1 and where they are in names_1
[Lia, Lib] = ismember(names_2, names_1, 'rows')

values_2(Lia) = values_1(Lib(Lib ~= 0)) % assign values accordingly

Lia will look like [0, 0, 0, 1, 0, 0, 1, 0]

and Lib will look like [0, 0, 0, 1, 0, 0, 2, 0]

and values_2 will look like [0, 0, 0, 834240000, 0, 0, 9951600, 0]

Check out ismember if you wish.

Hope this helps.

NOTE: if you run into trouble you could try to substite zeros with

values_2 = nan(length(names_2), 1)

[Emiliya Taskova]

Thank you so much! Everything worked now and I managed to get the output that I wanted!