Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone,
I have a table with 7 columns and 12000 rows contains learners' survey results.
One of the columns contains the students' comments (string). These strings may contain one or more lecturers' name.
I am trying to create a query using M language that allows me to identify the strings with the lectures' name and replace the lecturers' name with the word "Lecturer".
Also, another table includes the list of lecturers' name (1 column, 2000 rows).
I hope it makes sense.
Thank you,
Ata
There are many examples available for this requirement. Here's one of them: Bulk Find And Replace In Power Query | How To Excel
Thank you Ibendlin. Appreciate your response.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
3 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
6 | |
1 | |
1 | |
1 | |
1 |