Hi Doug, I have a list of keyword would like to search in the table, how can I modify the "keyword" query to show that? Currently, only allow to search one value.
Hi Doug. Awesome trick! I've been doing something similar, but just on one column using the key parameter as a filter input. Brilliant use of a conditional column to make the key search across multiple columns! Thanks for all the great tips and lessons.. much appreciated :)) Thumbs up!!
Hi Doug, Great video! Is it possible to add a condition where it looks for that exact word. For example, if I wanted to the pull the word "Hit" out of three columns, it currently brings back words which have that word within it i.e. "White"
Hello Doug. I assume that you can do this key word search based on multiple columns and multiple values per column (essentially, a separate sheet). Correct? Meaning, in your example, you have single key column value table. I assume that this can be with multiple columns and more values per column.
Hello Doug, quick clarification - suppose I have a dataset with random text including ticket numbers which needs to be extracted however there is a chance that two or three sequential numbers could come as reference like for example in comment "ticket-4591 datatasktype" could match with search keywords of "ticket-4","ticket-459" etc... Do you have any suggestions to avoid this?
Thanks great video!. Pls can you do a video on exact keyword search, i.e. a comment contain list of { "Street", "String", "Start", "St", "Starch", "Stung"} but I want to filter only for "St".
Hi.. Doug will confirm, but I think you would use something like: = Table.SelectRows(#"Changed Type", each Text.Contains([YourColumnName], YourKeyName)). I just did one of these.. so sharing my experience using Text.Contains(). Good luck!
@@wayneedmondson1065 thanks for the reply but I the method you suggested will not work doing exact keyword search. I only want the comments that contain exact word "st"
Some of my column values are empty and i am getting an error "Error: We cannot convert the value null to type Logical." which means that Power Query cannot search empty cells. How do you get past that?
Hi Doug,
I have a list of keyword would like to search in the table, how can I modify the "keyword" query to show that? Currently, only allow to search one value.
Thanks Doug! Another excellent and practical no nonsense video!
Glad you liked, thanks for the comment!
Useful...Thank you Doug!
Hi Luciano, you’re welcome!
Awesome thanks for sharing
Can we search list of key words ..?
maybe one of these? th-cam.com/users/DougHExcelsearch?query=power%20query%20keyword
Hi Doug. Awesome trick! I've been doing something similar, but just on one column using the key parameter as a filter input. Brilliant use of a conditional column to make the key search across multiple columns! Thanks for all the great tips and lessons.. much appreciated :)) Thumbs up!!
HI Wayne, very cool! Using the filter and passing the parameter is another great trick to accomplish this. Bravo!
Hi Doug, Great video! Is it possible to add a condition where it looks for that exact word. For example, if I wanted to the pull the word "Hit" out of three columns, it currently brings back words which have that word within it i.e. "White"
Thank you so much!
You’re welcome!
Hello Doug. I assume that you can do this key word search based on multiple columns and multiple values per column (essentially, a separate sheet). Correct? Meaning, in your example, you have single key column value table. I assume that this can be with multiple columns and more values per column.
Should work. An alternative would be to append the looked up columns as one table.
Hello Doug, quick clarification - suppose I have a dataset with random text including ticket numbers which needs to be extracted however there is a chance that two or three sequential numbers could come as reference like for example in comment "ticket-4591 datatasktype" could match with search keywords of "ticket-4","ticket-459" etc... Do you have any suggestions to avoid this?
See if any of the other video in this playlist would give an idea th-cam.com/video/_DnMuCw0IyQ/w-d-xo.html
can we do that using VBA instead?
Sure you can almost done anything with VBA!
Thanks great video!. Pls can you do a video on exact keyword search, i.e. a comment contain list of { "Street", "String", "Start", "St", "Starch", "Stung"} but I want to filter only for "St".
Hi.. Doug will confirm, but I think you would use something like: = Table.SelectRows(#"Changed Type", each Text.Contains([YourColumnName], YourKeyName)). I just did one of these.. so sharing my experience using Text.Contains(). Good luck!
@@wayneedmondson1065 thanks for the reply but I the method you suggested will not work doing exact keyword search. I only want the comments that contain exact word "st"
Exact match...I may need to put together another video for that 😉...have you tried space before and after the St word in the if clauses?
@@DougHExcel no I haven't I am going to now, thanks
@@DougHExcel it doesn't work if in the comment a word end with internationalist or philanthropist.
Some of my column values are empty and i am getting an error "Error: We cannot convert the value null to type Logical." which means that Power Query cannot search empty cells. How do you get past that?
null and blanks may be treated differently. have you tried to change null entries to blanks?