This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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:
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:
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!
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.
Hi @Antalus ,
This is the solution with fuzzy match tool .