Bulk Replacements

[Spyderturbo007]

I'm working with two CSV dumps from two different eCommerce platforms. There was a migration last year from platform a to platform so I'm trying to combine the sales data. The issue is that some (not all) of the store names are different. I'd like to bulk change the store names that are different in the table from the old platform so they match the new platform. I have another table with the correlation between store names.

I know I can use the replace function of power query, but there are tons so I'd be doing them one at a time and it would take forever.

Is there a way to automate it if I were to make a table with the correlation between the two tables?

Old Platform:

Store Name

MECHYTHLAX

MECHYTHLAX

CVACDIVCHAMP

SFIGHT

CITIZENSFIRECO

SLFIRE

New Platform:

Store Name

Mech Lacrosse

Mech Lacrosse

Divisional Champs

SFIGHT

Fire Company

SLFIRE

Correlation:

Old Name	New Name
MECHYTHLAX	Mech Lacrosse
CVACDIVCHAMP	Divisional Champs
SFIGHT	SFIGHT
CITIZENSFIRECO	Fire Company
SLFIRE	SLFIRE

Thank you!

 

[alansidman]