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)
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