Active Member
December 21, 2020
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
October 5, 2010
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
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
November 8, 2013
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.
1 Guest(s)