Trying to do vlookup in Alteryx

[Asad_Ali]

Hi guys!

This is my first post on this platform and i am just starting to learn Alteryx so have really basic question.

I have two sets of table as shown below and Idea is to find the lookup value in table 2 and bring it in table 1, and incase it is not available in table 2 then take the original value. 

I hope the example shown below is easy to understand, I am bit stuck so shall really appreciate quick help.

End note:

I used the join tool to do this but it only shows values for those that are available in table 2 everything else is ommited.

 

[Qiu]

@Asad_Ali 
Multiple acceptance of solution is allowed😁