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]

Hi @Uzi 

Its working for me

Its should work whats the issue your are facing.

Here is a workflow for the task.

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 😀👍

[Emil_Kos]

Hi @Uzi,

Please look into the join tool. There is a help which might be helpful to understand it better:

https://help.alteryx.com/current/designer/join-tool

To help you I have prepared a workflow:

Output(my output is a little bit different as I have used a little bit different data)

Please let me know if you have any questions.

If this is helpful please mark as a solution.

[Uzi]

I realy dont get it... I did it the same like you guys but the table stays empty 😕

It is creating the header and so on but its not filling the table

[atcodedog05]

Hi @Uzi 

You can share your workflow. We can help with whats the issue 🙂

[Uzi]

I cant share it is to confidential 😄 

Just let me check how can I cange the files or data

[atcodedog05]

okies 🙂👍

[Emil_Kos · Accepted solution]

Hi @Uzi 

Propably you have tailgating spaces. You need to use data cleansing tool in order to clean your data:

https://help.alteryx.com/current/designer/data-cleansing-tool

If you need help using it check this video:

https://www.youtube.com/watch?v=FzefmS9Fu7Y

[atcodedog05]

@Uzi 

I agree with @Emil_Kos spaces can be a issue.

[Uzi]

yes, thank you @Emil_Kos . This was the Solution 

Best