What kind of join will work to merge these two tables
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
alpedhuez
el 12 de Dic. de 2020
Respondida: Jeff Miller
el 13 de Dic. de 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 comentarios
Image Analyst
el 12 de Dic. de 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().
Respuesta aceptada
Más respuestas (0)
Ver también
Categorías
Más información sobre Loops and Conditional Statements en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!