Join tables based on month values

Question

shi hao lee 2021-3-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/787764-join-tables-based-on-month-values

回答： Prahlad Gowtham Katte 2022-2-14

在 MATLAB Online 中打开

I want to join the tables by month to give 3 rows, one for each month.

The first row should be Jun-2018, Jun-2018. Second should be Jul-2018, Jul-2018. Last row should be Aug-2018, Aug 2018.

However, the original data is 1st June and 2nd June and it is causing the join to give me 6 rows.

a = table(datetime({'01-Jun-2018'; '01-Jul-2018'; '01-Aug-2018'}))
b = table(datetime({'02-Jun-2018'; '02-Jul-2018'; '02-Aug-2018'}))
a2 = table(datetime(a.Var1,"Format","MMM-uuuu"))
b2 = table(datetime(b.Var1,"Format","MMM-uuuu"))
outerjoin(a2,b2,'Keys','Var1')

Any solutions?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Prahlad Gowtham Katte 2022-2-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/787764-join-tables-based-on-month-values#answer_895435

在 MATLAB Online 中打开

Hello,

As per my understanding of the query, you are trying to join two tables with similar month values using outer join. Your intended result can be achieved if you set MergeKeys to true in outer join function. If you replace the line which calls outer join function with the following it would resolve the problem.

outerjoin(a2,b2,"Keys","Var1","MergeKeys",true);

For more detailed explanation about the outer join function following link can be useful.

https://www.mathworks.com/help/matlab/ref/outerjoin.html

Hope it resolves your problem