Merge two tables different size

[Uzi]

Dear all I have two tables which i want to merge. They have different size. Example: 

and the Output should be like that: 

I tried it with the Join tool but have no Idea why it didn't work. Thanks for the help 

[atcodedog05]

Glad to hear it got solved @Uzi 🙂

Happy to help 🙂

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂

[Uzi]

Well now im running into a new issue... the output hast just 4 matches. It is using just the first 4 matches and ignroes the rest. for example like this: 

[atcodedog05]

Hi @Uzi 

Is it the same sample data which is used as above?

[Uzi]

No it is my own.. When Im looking at the Left side then it is without the right vallue and the middle join is with the rightvalue but only limited to the number from the right table 😕

[Uzi]

ok I found the problem. Im matching a text and the text is not 100% exact. There is sometimes a word more in the table which is not in the other tabel... is it possible to match it like "when 90% of the text is the same but not 100%"? 

[atcodedog05]

Yes, you can use find and replace thats more flexible.

[atcodedog05]

Hi @Uzi 

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[atcodedog05 · Accepted solution]

For this tool.

Table 1 can have extra text but Table 2 key should be present in Table 1 key.

The Table 2 key should be present in Table 1 key. It works like a keyword search.

[Uzi]

Looking good, thank you very much 🙂