Hello im pretty new to alteryx and having some trouble with joinin two sheets.
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 thr excel file 1
thanks for the help!
Solved! Go to Solution.
Hi @mrbubi001 to match your expected output I just joined by postion its a radio button in the tool configuration window.
Hi @mrbubi001 ,
This is a bit of a strange one as you have no common key but appear to be joining on record position.
I've built the attached workflow which joins on that logic:
This is the join configuration:
This gives the following:
I hope this helps,
M.
Hello @mrbubi001 ,
to join data you can do it easily with the join tool. by adding other outputs together with the join output tool you can also take into account those values which are not present in the second file, just in case you don't want that information to be left back.
Regards