Forum Discussion
Need help in doing keyword Search
Hi Anonymous
You can add a custom column in table and input the following code.
=List.Accumulate(List.Numbers(0,Table.RowCount(KeywordSearchB),1),"No",(state,current)=>if Text.Contains(Text.Lower([Product Title]),KeywordSearchB[KeywordSearch]{current}) then "Yes" else state)For the keywordsearcha table, just replace the
it can work.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
Based on your description, What does the column you are referring to look like? Can you provide some pictures so that I can provide you with more help? Please hide your private information on the photos.
Best Regards!
Yolo Zhu
Best Regards!
Yolo Zhu
Hi Yolo,
This is a sample of how it looks like.
This is my mapping tables where it will need to find keywords that is related to all this.
It is based in a file in Sharepoint
and My Data looks like this:
so i will need to search if Product Title consist of the keyboard shown in the above table in SharePoint and return No.
I have used a Power Query to get the Mapping table as shown above