Replace text in a column in one query with mapped data in another

[jkapso751]

Hi all,

I'm looking a way to replace text in a column in one query with mapped data in another.  In the example below, I would want to replace all the names in Column1 with either Group1 or Group2 from Column2 (in Query2).  I'm guessing I'll need to use the "Table.ReplaceValue" function.  Is there a way to refer to other query tables in the formula syntax?

Many thanks!

[jkapso751 · Accepted solution]

Found the solution in these two very helpful videos:

Power Query: Bulk Replace Values from a table in Excel & Power BI - YouTube

(No/low code solution using merge)

Quick Tip - Replace value with another column in Power Query - YouTube

(Replacing nulls with text in another column)