HI All,
I have 2 data files where one of the common column is Company Name. I want to do a join on company name but it needs to be a like type join..so all variations of the name are matches.
File 1 :
Company | Country |
XYZ | UK |
ABC | Brazil |
File 2:
company name | loc | add | url |
XYZ | UK | 123 | www.xyz.com |
XYZ Ltd | Russia | 111 | www.xyz.com |
ABC Corp | US | 11 | www.abc.com |
Desired output:
Company | Company name | Loc | Add | URl | |
XYZ | XYZ | UK | |||
XYZ | XYZ Ltd | Russia | |||
ABC | ABC Corp | US |
What would be the best way to achieve this type of join.
Thanks
Sam
Solved! Go to Solution.