MATLAB Answers

What kind of join will work to merge these two tables

16 views (last 30 days)
alpedhuez
alpedhuez on 12 Dec 2020
Answered: Jeff Miller on 13 Dec 2020
I have table T1
date city vistors
---------------------
January 1 2020 NY 100
January 2 2020 NY 200
January 1 2020 SF 150
January 4 2020 SF 50
I have table T2
city state
----------
NY New York
SF Calfiornia
I want Matlab to create T3
date city vistors state
---------------------
January 1 2020 NY 100 New York
January 2 2020 NY 200 New York
January 1 2020 SF 150 California
January 4 2020 SF 50 California

  2 Comments

Image Analyst
Image Analyst on 12 Dec 2020
Make it easy for us to help you, not hard. Give us code to create the input tables T1 and T2.
What happens if you just simply try the various flavors of join? Maybe you'll stumble across the right one.
One non-join way is to simply use a for loop and ismember().

Sign in to comment.

Accepted Answer

Jeff Miller
Jeff Miller on 13 Dec 2020
Try
T3 = join(T1,T2,'Keys','City')

  0 Comments

Sign in to comment.

More Answers (0)

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by