Log In
Register
Home
Active Member
December 21, 2020
Offline
Hi ,
Continuing searching text for string in power query with a table over 14,000 rows.
I'm attaching the data here to do some testing.
H - Thanks
See Answer
July 16, 2010
Offline
Hi and welcome to our forum!
Your file didn't get attached. Please try again and be sure to click the 'Start Upload' button after selecting your file.
Mynda
Active Member
December 21, 2020
Offline
Hi, uploaded the file again.
October 5, 2010
Offline
Hi,
Have you read and tried the code from these posts
https://www.myonlinetraininghu.....ower-query
https://www.myonlinetraininghu.....ower-query
You haven't said how you want the results to look so I've produced a table with the strings that match in a separate column - see attached.
Regards
Phil
Answers Post
November 8, 2013
Offline
You can also try this query, might be faster:
let
Source = Excel.CurrentWorkbook(){[Name="Data"]}[Content],
WordList = List.Buffer(Excel.CurrentWorkbook(){[Name="WordList"]}[Content][Parent Item]),
#"Added Custom1" = Table.AddColumn(Source, "Custom", (x)=> Text.Combine(List.Select(WordList, each Text.Contains(x[item], _ ,Comparer.OrdinalIgnoreCase) ),","))
in
#"Added Custom1"
You can remove the red argument if Case should not be ignored.
Active Member
December 21, 2020
Offline
Thanks for helping Philip & Catalin.
I just started to learn PQ for 2 weeks ago. 🙂
Learning form your posts that makes me spent a lots of time but really helpful everyone.
Can you share more stuff to learn PQ? Highly appreciated.
Thank you!
Hue
1 Guest(s)
