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 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
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.

 

 



Bulien

atcodedog05
22 - Nova
22 - Nova

Interesting, so many different approaches for this usecase 🙂

 

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

 

Labels