Forum Discussion
How to replace value when cell contains keyword
I have this sample table with two columns: Company and Amount. In this table, there are four different companies: Amazon, Google, Apple, and Microsoft. However, as seen in the table, the company's na...
From my point of view it shall be more logic added to the extracting of companies name. Otherwise how Power Query know that in "Google Search" and "Apple Search" company name is not "Search" but "Google" and "Apple". Such logic could be separate table with all possible companies names.
With that we may add custom column to table as
each List.Intersect( {Text.Split([Company], " "), Companies[Company]} )and extract value from it.