Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Join the records with Contains Similar names

Vishwak
7 - Meteor

Hi I need to join(Vlookup) the Names in two different files, but my issue is that i need to join by using Contains option in the name.

example : First file records : Tree                          
                 Second File Record  : Treewith02/21/2023
still i need to Join both the records by using Join tool. because both contains tree as common word.
Please guide me in this.

2 REPLIES 2
BransonJamesFarley
8 - Asteroid

Would using something like this achieve what you are looking for? If not could you provide me with some more details? 

binu_acs
21 - Polaris

@Vishwak Find and replace is an option for your use case

image.png

Labels
Top Solution Authors