Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Ben-Dev
Helper II
Helper II

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!

2 REPLIES 2
v-kkf-msft
Community Support
Community Support

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

 

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!

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors