Forum Discussion
Where do i start with a tag search function?
Hi Anonymous ,
It is recommended that you create a matching table to match the primary table in Power Query.
Here's the reference.
Power Query - Matching a value from a list using power Query - Microsoft Community
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Thank you for the response. In the solution you provided, what i am looking for is that the table is already populated, but then I would want to look for the best match based on keywords. For example. I might need to seach for "Bahrain", "Mob" and "Viva".. I want it to return the 1 record in the table with all 3 with 100% match, but then indicate a match to just Bahrain and Mob, with a 66% match and Mob or Bahrain with a 33% match etc or austria and mob being a 33% match based on Mob etc. Ive thought about 3 columns, The document, the tag and then the number 1 if that tag is relevant to the document. Then filter the tag row based on the tags i want to search for and then do a count in the number row, and order from the highest count to lowest. What are your thoughts on that?
Lola