December 18, 2018
Hello,
I have Table1 containing a column called [Business Lines]. I have Table2 containing [Text String] and [Operating Area].
I'm trying to perform a type of Merge Query, where it will search Table1[Business Lines] for the first match of Table2[Text String] and return Table2[Operating Area].
I tried fuzzy Merge Query and it didn't function at all like I had hoped. I also came across some code online at this page: https://stackoverflow.com/questions/62327202/power-query-function-to-search-for-matching-keywords-in-a-table-of-lists-and-ret
which was very close, but also came back with Operating Areas that simply did not match.
Any help is, of course, greatly appreciated.
1 Guest(s)