outerjoin using Row Names as key?

Question

Anil 2016-1-6

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/262818-outerjoin-using-row-names-as-key

评论： FM 2023-1-31

The join operation supports table merging using the table row names as key (using the flag 'keys','RowNames'). This functionality doesn't appear to be available when using innerjoin or outerjoin? Is there a workaround for this (I'm currently considering creating a wrapper function that explicitly adds the rownames to a column in both tables, joins using the column, and then readds the rownames, but I feel this may be fairly slow?)

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

请先登录，再进行评论。

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

Answer 1

Peter Perkins 2016-1-6

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/262818-outerjoin-using-row-names-as-key#answer_205299

Row names have to be unique, so I think you're wanting to do something that might be described as more of a merge than a full-blown inner/outer join where there might be many-to-many matches. And if you have a one-to-one correspondence between the two tables, the join function does accept 'RowNames'. But you're correct, the inner/outerjoin functions don't support this directly.

Your idea of adding he row names as an explicit key var will work, I think you could do also use setdiff on the row names and then concatenation. Hope this helps.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

FM 2023-1-31

For the sake of consistency and convenience, I wonder of TMW would add the ability to inner/outer join based on RowNames. It would certainly streamline the coding compared to having to add the variable and later to remove it.

请先登录，再进行评论。