Here comes Power Query Challenge 3. There is a table which has Original Text and there is another table which contains the list of words which need to be replaced.
After replacement, output should look like Result.
Try to do maximum steps through UI and minimize writing M-code.
Of course, the query should be dynamic i.e. even if number of words increase or decrease in a line OR/AND number of rows increase or decrease, the Query should give right result on Refresh.
The problem file related to this challenge can be downloaded from PQ Challenge_3_Problem
The solution to Power Query Challenge 3 will be published after a week i.e. on Wednesday, 13-Oct-21.
Solution link – Solutions to Power Query Challenges – 1 to 7
Power Query M function reference – PowerQuery M | Microsoft Docs