Question 20548 in Mysql Question posted in
The official MySQL documentation can be found here.

Replacing values based on condition in Power Query – Mysql

I want to replace some acquaintance values by keywords to specific value, converting both "google" and "searching google" to "seo"

I tried replace but you should specify all the values to replace with and that’s not possible.
if there is a solution with "contain" function i think it would help but i couldn’t find it.

Tags:

2

Answers


  1. 0

    You need to add a conditional column as explained here in this tutorial- Here

    This is basically a simple new conditional column with if/else condition as shown in this below image-

    enter image description here

    Login or Signup to reply.
  2. 0

    enter image description here

    enter image description here

    let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Custom1 = Table.TransformColumns( Source, {{"Column1",(x)=> if Text.Contains(x, "google") then "seo" else x}})
in
    Custom1
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search