replace value in sku if the sku match with another excel's sku

[Anzrey]

Hi,

I am currently trying to replace the name of my product based on SKU. I have another excel sheet that have those SKU and the new name ready to replace the excel data I have which doesn't have the new name. I am not very good with alteryx need some help and advice on it. Thanks in advance.

Here are some example of what I am trying to do
The example data:

sku	skucheck	name	new name
a	a	a1	a11
b	b	a2	a12
c	c	a3	a13
d		a4
e		a5

The one that without new name will have their old name remain.

And the result I wanted is: 

sku	name
a	a11
b	a12
c	a13
d	a4
e	a5

[AndrewS · Accepted solution]

Hi @Anzrey,

I've created a workflow that I think solves your problem - I wasn't 100% sure on what your inputs were so I made up what I thought.

Hope this help.

[Anzrey]

Thanks a lot, have a nice day.

[AndrewS]

@Anzrey Not a problem, happy to help.