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.
Solved! Go to 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.
Interesting, so many different approaches for this usecase 🙂
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/join-two-inputs/m-p/833552#M204669