Matching Values from one Table to Another

Hi everyone,

Is there a way from me to match the numbers in two dataset and extract the values in the row?

For instance,

This is my first table:

This is my second table:

What is would like to do---> I would like to search for my second table values in the first table, specifically under "FirstVID" and "SecondVID". Once I have a match of these values, I would like the numbers on "FirstVID" or "SecondVID" to be replaced by the string "AV".

Is this posssible?

Thank you.

Answer 1

[Walter Roberson]

Change

FirstVID = NewTab (:,["FirstVID"])

to

FirstVID = NewTab {:,["FirstVID"]};

[Jana Sarran]

Thank you!. It worked.

Answer 2

[Joe Vinciguerra]

Veh = [2007; 1265; 1266; 1269];
FirstVID = [1881; 1269; 2007];
SecondVID = [1892; 2188; 1266];
T = table(FirstVID, SecondVID);

% find data common to each table
[~, ~, ib1] = intersect(Veh, T.FirstVID);
[~, ~, ib2] = intersect(Veh, T.SecondVID);

% Convert to cell since you want mixed data types
T.FirstVID = num2cell(T.FirstVID);
T.SecondVID = num2cell(T.SecondVID);

% using the indexing found above, replace with "AV"
T.FirstVID(ib1) = {'AV'};
T.SecondVID(ib2) = {'AV'};

disp(T)

    FirstVID    SecondVID
    ________    _________

    {[1881]}    {[1892]} 
    {'AV'  }    {[2188]} 
    {'AV'  }    {'AV'  } 

Alternately, you could avoid converting to cells and simply repalce the indexed values with NaN, unless having it read "AV" is necessary.

[Jana Sarran]

Thank you for the help.

I tried using this code but I am getting an error message.

Please see the attached pdf document for the message.

It says that there is an error using Tabular/Intersect

[Joe Vinciguerra]

Glad you were able to resolve your error in the other thread. Please accept my answer.