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

[Timo97]

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: 

Hello	10
Hello	25
Hello	69
Hello	35
Hello	96
World	55
.......

My goal is now to create something like this:

Filed1	Name1	Name2	Name3	Name4	Name5
Hello	10	25	69	35	96
World	55	...	...	...	...

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. 

[mceleavey · Accepted solution]

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:

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

This gives the following output:

I hope this helps,

M.

[atcodedog05]

Interesting, so many different approaches for this usecase 🙂

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