Appending two tables of different sizes

1 view (last 30 days)
I am matching two tables LC and Bordo using the year and the quarter columns that are common between the two. LC is a bigger table with more rows and columns. So I matched using the following:
[isinB, Brow]= ismember([LC.yy,LC.Quarter],[Bordo.Year,Bordo.quarter],'rows');
How can I append to LC table the part of Bordo table that matched based on year and quarter those in LC table?
  1 Comment
Peter Perkins
Peter Perkins on 6 Jun 2017
Danielle, you're going to have to say specifically what you mean by "append". It sounds like maybe some kind of join operation, as Walter suggests. But a short example is what's needed.

Sign in to comment.

Answers (1)

Walter Roberson
Walter Roberson on 5 Jun 2017
innerjoin() perhaps ?

Categories

Find more on Tables in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!