community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Join with Substring

Atom

Hi,

 

i have 2 tables i want to join: One with Usersnames, the other with a lot of Datasets and an textfield where there may be a username:

 

Table User:

Username      UserID

Andreas           5

Georg              12

Tim                  8

 

 

Table Data:

Hardware        Details

Laptop             This is the Laptop of Andreas

Callphone        This is the Phon of Tim the great

Chair                George has a new chair

 

and i want to get a result like this:

 

Table Join:

Hardware        Details                                             UserID

Laptop             This is the Laptop of Andreas          5

Callphone        This is the Phon of Tim the great     8

Chair                George has a new chair                  12

 

so a join with only a part of of a Field.

 

I have about 30k Users an about 1 Mio Datasets...

 

Sorry for my English….

 

Thanks for your reply!

 

Andreas

Alteryx
Alteryx

Hey @Antalus 

 

My take on it was to use a Find and Replace to find where there was a match in "Username" and "Details".  If it finds a match, append Username and ID.

 

find_replace.PNG

 

Sample attached

 

 

 

 

Highlighted
Quasar

Hi @Antalus ,

This is  the solution  with  fuzzy match tool . 

Labels