Hello everybody, i am having trouble joining three columns and i don't know what else to do. I have three different columns generated by alteryx, Example:
DATA A |
1 |
2 |
3 |
4 |
5 |
DATA B |
8 |
123 |
43 |
DATA C |
32 |
4 |
If i use the union tool the output is this one:
DATA A | DATA B | DATA C |
1 | ||
2 | ||
3 | ||
4 | ||
5 | ||
8 | ||
123 | ||
43 | ||
32 | ||
4 |
And i need this one:
DATA A | DATA B | DATA C |
1 | 8 | 32 |
2 | 123 | 4 |
3 | 43 | |
4 | ||
5 |
Maybe it is a stupid question, but i have tried a lot of options unsuccessfully.
Thank you so much for your help!!
解決済! 解決策の投稿を見る。
@lacubata I would suggest adding a Record ID tool after each of your three inputs. Then use a Join Multiple tool using the RecordID field to Join by Specific Fields.
You can also use the "Join by Record Position" in the Join Multiple tool:
Thank you so much! As i thought it was an easy one... I tried to use the record ID but my mystake was to use the simple join, so a lot of records were out.
Thank you again!