Alteryx Designer Discussions

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

join two files one are the cloumn name the other one are the values

Timo97
7 - Meteor

Hello Alteryx community,


I have a pretty simple question. I want to unite two excels. 

The first file has 5 column names (name1, name2, name3....) like this...

Name1

Name2
Name3
Name4
Name5

 

 

The other one is a bit more complicated than the first one. 
There are two columns, one with 5 times the same name and the other with numbers

For example: 

Hello10
Hello25
Hello69
Hello35
Hello96
World55
....... 

 

My goal is now to create something like this:

 

Filed1Name1Name2Name3Name4Name5
Hello1025693596
World55............

There is probably a simple way, but I looked now for hours and can't find anything. 

 

Would be really thankful if somebody could help me with this. 

 

2 REPLIES 2
mceleavey
17 - Castor

Hi @Timo97 ,

 

This is not ideal as you are relying on position as there is no logical join between the two. Providing there is consistency of field position then this will work:

 

mceleavey_0-1634056549316.png

 

I've used the cross-tab tools to get the grid in the correct order, then unioned using position.

 

This gives the following output:

mceleavey_1-1634056599162.png

 

I hope this helps,

 

M.

 

 

atcodedog05
21 - Polaris

Interesting, so many different approaches for this usecase 🙂

 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/join-two-inputs/m-p/833552#M204669

 

Labels