How to Join 2 inputs into empty cells with certain condition in ALteryx

[priscon]

Hi all,

Please take a look at the example below, I want data from Spreadsheet #1 to be on Spreadsheet #2 if "Name" column Matches , then "Comment" needs to be added in the empty cell. However, Spreadsheet #2 has already comments for other names. How can this be done in alteryx? can it be done as a formula?

Name	Count	Comment
Laura	5	Yes
Anna	4	NO
Yailin	3	NO
Henderson	2	Yes
Tom	1	No
Name	Count	Comment
Laura	-	-
Anna	-	-
Yailin	-	-
Henderson	-	-
Tom	1	No
Robert	-	YEs
Emilio	3	No
Desired results
Name	Count	Comment
Laura	5	Yes
Anna	4	NO
Yailin	3	NO
Henderson	2	Yes
Tom	1	No
Robert	-	Yes
Emilio	3	No

[SPetrie]

Here are a couple options that may get you what you are looking for.