Vlookup solution using Alteryx

[Anwita]

I have two datasets which are connected using a common identifier with same column header. one dataset (A) is unique at this common identifier level but the other one (B) isn't, meaning the other dataset B has multiple rows for same identifier. In the manual process i use vlookup to fetch missing data in dataset A from dataset B basis common identifier. 

which translates to my problem statement: what combination and configuration of tools do i need to use to achieve same results using Alteryx, that is I want to get the relevant columns from dataset B but only for those many rows that are present in dataset A 

[OTrieger]

@Anwita 
Join Tool or Find and Replace (however Find and Replace will work only for string data type)

[Anwita]

But in Join tool, the relevant columns from dataset B are obtained only in the case of Inner Join, not for the outer left join

[alexnajm]

That’s correct - columns will come across from dataset B with an inner join or a left outer join (join plus union of the L and J anchors): https://knowledge.alteryx.com/index/s/article/Left-Right-and-Full-Outer-Joins-are-easy-1583461559334

there is an article and an interactive lesson on vlookups that you can watch to see the main difference between both solutions: https://knowledge.alteryx.com/index/s/article/Alteryx-for-Excel-Users-How-to-do-a-VLOOKUP-in-Alteryx... & https://community.alteryx.com/t5/Interactive-Lessons/VLookUps-with-Designer/ta-p/80201

if you are still stuck, please tell us what is wrong with a concrete example so we can help further