Join two sheets with same id

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!

excel file 1.xlsx

excel file 2.xlsx

Python

Transformation

Accepted answers

mceleavey

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,

mceleavey_solution.yxmd

All comments

JosephSerpis

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

mceleavey

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,

mceleavey_solution.yxmd

afv2688

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

join data.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703