cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
PhilC Regular Visitor
Regular Visitor

Keyword search - dealing with plurals when using List (not Text) matching

Hi, further to the post already resolved (see here https://community.powerbi.com/t5/Power-Query/Keyword-search-to-return-exact-word-match/m-p/723186#M2... ), I would like to know if anyone has an approach for dealing with plurals for a keyword list?

 

Using the list approach rather than Text.ContainsAny is beneficial as it eliminates false matches, ie soft / software, but does not pick up where the relevant keyword is appropriately a part of a larger work, a plural being the most obvious occurance.

 

I am currently duplicating my keyword list and appending "s" to each one, thus loading a double set of keywords.  Am wondering if anyone has a more scientific approach for keyword matching using a keyword list.

 

Cheers

Phil

 

@ImkeF   @MarcelBeug   (have linked you both as you have helped or I have used your posts related to this)

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Keyword search - dealing with plurals when using List (not Text) matching

Hi @PhilC ,

you can either transform the existing List to a list of plurals and append it to your original list.

A simple method would be this

 

List.Transform(yourList, each _ & "s")

or you search for an API that delivers more accurate versions.

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Imke Feldmann

How to integrate M-code into your solution -- Check out more PBI- learning resources here -- Performance Tipps for M-queries




1 REPLY 1
Super User
Super User

Re: Keyword search - dealing with plurals when using List (not Text) matching

Hi @PhilC ,

you can either transform the existing List to a list of plurals and append it to your original list.

A simple method would be this

 

List.Transform(yourList, each _ & "s")

or you search for an API that delivers more accurate versions.

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Imke Feldmann

How to integrate M-code into your solution -- Check out more PBI- learning resources here -- Performance Tipps for M-queries




Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Top Kudoed Authors
Users Online
Currently online: 247 members 2,661 guests
Please welcome our newest community members: