Hi, I am trying to merge two dataset by var1 but with a lookup method rather than exact match merge. Please help Data Set 1 Var1 var2 var3 John Doe one yes John Dao two no John Laou one yes Laou John two yes Ram Prasad Neula one yes Ram Neula two no Prasad Ram Neula one yes Neula Ram Prasad two es Ram Prasad Doe one no California Mayor City one yes California City Mayor Town two es California Mayor one no California City Mayor House one yes Dataset 2 var1 var4 var5 John something1 something2 Ram Prasad something3 something4 california city mayor helo helo2 Desired Dataset Var1 var2 var3 var4 var5 John Doe one yes something1 something2 John Dao two no something1 something2 John Laou one yes something1 something2 Laou John two yes Ram Prasad Neula one yes Something3 something4 Ram Neula two no Prasad Ram Neula one yes Neula Ram Prasad two es Ram Prasad Doe one no Something3 something4 California Mayor City one yes California City Mayor Town two es helo helo2 California Mayor one no California City Mayor House one yes helo helo2
... View more