Folding Table.Join By Using Table.View - keyEqualityComparers

[Ben-Dev]

Hello,

Table.Join takes an optional keyEqualityComparers argument. According to the docs, this "is currently intended for internal use only."

When handling OnJoin from a Table.View, the join key details passed into the handler include equality comparers. Will there be cases where Microsoft's internal use of Table.Join's keyEqualityComparers argument leads to my OnJoin being passed a non-default comparer, or can I expect that OnJoin will be always and only passed the default comparer (that is, Comparer.Ordinal)?

Thank you!

[v-kkf-msft]

Hi @Ben-Dev ,

There is no official documentation with information about 'keyEqualityComparers', perhaps you can refer to the following thread: joinAlgorithm and keyEqualityComparers 

Best Regards,
Winniz

[Ben-Dev]

Hi @v-kkf-msft, 

Thanks! Any way we can get some insight from the custom connector dev team here?  If I'm implementing a Table.View, my OnJoin handler is passed equality comparer(s). Since Power Query is passing them to my handler, it seems like I need to know what to do with them. 🙂

Am I supposed to do something with them, or is the official Microsoft position that I should ignore them?

Thanks!