Mapping data in a column and replacing with new names

[BrianDeg]

Hello! I am looking for some help with an Alteryx workflow I am creating. I have included examples below. I have created a flatfile of revenue data of various items sold at various stores. The names in the "column" item names are too specific. As such, I have another file in which I have mapped the specific names to more general categories. I am hoping to replace the specific item names with the general categories. The below example should provide more details. Thank you so much for your help!

Here is the current output of the workflow aka "the flatfile":

Store number	Item name	Revenue
33	Pencil	300.5
33	Marker	211.21
33	Paper	57.24
33	Laptop	3272.22
46	Pencil	21.12
46	Marker
46	Paper	232
46	Laptop	1000.12

Here is the mapping file I have on a separate spreadsheet that I am bringing into my workflow:

New name	Old name
Writing utensil	Pencil
Writing utensil	Marker
	Paper
Electronics	Laptop
Electronics	Charger
Other supplies	Rulers
	Magnets

Here is my desired output. You will see that the names in the right column have been replaced with the names in the left column in the flatfile:

Store number	Item name	Revenue
33	Writing utensil	300.5
33	Writing utensil	211.21
33	Paper	57.24
33	Electronics	3272.22
46	Writing utensil	21.12
46	Writing utensil
46	Paper	232
46	Electronics	1000.12

[sparksun · Accepted solution]

Find Replace tool can easily make it.