Joining two sheets common Id and different values

[mrbubi001]

Hello

Sry for asking again! But the solution i posted was wrong in the first and i marked one of the answers as the solution and i repost it like i hoped i could.  

I have two sheets with some names, id's and no value and i have another with id and values. 

How can i combine the two different excel files in alteryx 

Sry i made the solution wrong on the first picture, i want the name and x to be the id and y to be put into the excel file 1

[JosephSerpis · Accepted solution]

Hi @mrbubi001 you can join your two excel sheets if you use a join tool with this configuration.