Join if String Contains
Hello,
I want to join two tables:
Table1
IdName123Steven Brown456
Lacie Garrison
789
Tobias Booker
Table2
Names CountrySteven Brown, Sandra Muller USAlex Hampton, Tobias BookerCanadaJanet BeemMexico
Expected Result
IdNameCountry123Steven BrownUS456Lacie Garrison 789
Tobias Booker
Canada
I am working with Data Flows at the moment and I can only see that we can do joins or lookups on exact matches, not on contains.
Any ideas are appreciated.
Hello, I want to join two tables: Table1IdName123Steven Brown456Lacie Garrison 789Tobias Booker Table2Names CountrySteven Brown, Sandra Muller USAlex Hampton, Tobias BookerCanadaJanet BeemMexico Expected ResultIdNameCountry123Steven BrownUS456Lacie Garrison 789Tobias BookerCanada I am working with Data Flows at the moment and I can only see that we can do joins or lookups on exact matches, not on contains.Any ideas are appreciated. Read More