Forum Discussion

Ben-Dev's avatar
Ben-Dev
Helper II
4 years ago

Folding Table.Join By Using Table.View - keyEqualityComparers

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!

Need Help

2 Replies

    • Ben-Dev's avatar
      Ben-Dev
      Helper II
      4 years ago

      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!