Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Join two sheets with same id

mrbubi001
6 - Meteoroid

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

 

mrbubi001_0-1638383136865.png

 

 

thanks for the help!

3 REPLIES 3
JosephSerpis
17 - Castor
17 - Castor

Hi @mrbubi001 to match your expected output I just joined by postion its a radio button in the tool configuration window.

 

Join_postion_01122021.JPG

mceleavey
17 - Castor
17 - Castor

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:

 

mceleavey_0-1638376525220.png

 

This is the join configuration:

mceleavey_1-1638376551731.png

 

This gives the following:

 

mceleavey_2-1638376569787.png

 

I hope this helps,

 

M.

 

 



Bulien

afv2688
16 - Nebula
16 - Nebula

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

Labels