What kind of join will work to merge these two tables

1 次查看(过去 30 天)
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 个评论
Image Analyst
Image Analyst 2020-12-12
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().

请先登录,再进行评论。

采纳的回答

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

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Loops and Conditional Statements 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by