How do you replace values in a column based on values in another column on Power Query Editor?

Question

Hello,&nbsp;My situation is as follows:&nbsp;&nbsp;I'm trying to replace values in a column based on values in another column, without changing every value in the data set.&nbsp;Example:&nbsp;Business Code&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Customer CodeABC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DEFABC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DEFABC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; GHIABC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; JKL&nbsp;I want to make so that any customer code with "DEF" is replacing "ABC" in Business Code, with "DEF" in Business Code, while not affecting the rest of "ABC"s in Business Code.&nbsp;Can anyone please help.&nbsp;Thanks.

sayaliredij · Accepted Answer

You can try this in Power Query&nbsp;You can create new conditional column using following Settings&nbsp;&nbsp;Rename Old Business Code column - as old columnand rename Newly Created column as Business Code&nbsp;Regards,Sayali&nbsp;If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help others find it more quickly.

Forum Discussion

How do you replace values in a column based on values in another column on Power Query Editor?

1 Reply

Related content

Query editor replacing values based on another column

Replace existing image with another

Query Editor - replace multiple values

Replace null values of one column to another column.

= Replace UNICHAR(10) in Query Editor