Skip to main content

Power BI

Needs Votes

Allow equal key column names in Table.Join

Vote (6) Share
Maxim Zelensky's profile image

Maxim Zelensky on 05 Sep 2017 14:38:09

In Table.Join function we can use same key column names for JoinKind.Inner option, but need to use different column names for other join types, like Left Outer, Right Outer etc. This limitation demand to add excessive steps for renaming duplicate columns before join and removing them after join.
As Table.Join is much faster and effective than Table.NestedJoin in complex preparation, this seems to be unnecessary and dilatory limitation and should be removed.

Comments (1)
Maxim Zelensky's profile image Profile Picture

Maxim Zelensky on 05 Jul 2020 22:58:14

RE: Allow equal key column names in Table.Join

the same idea on excel.uservoice.com: https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/31231804-allow-equal-key-column-names-in-table-join-power