Hello,
I have two different rows of data which have exactly the same header. How do I merge them into one output which contains both rows.
Data 1:
time | cost | resource | account number |
1 | 2 | 3 | 4 |
Data 2:
time | cost | resource | account number |
3 | 4 | 5 | 6 |
I want to get here (Merged data):
time | cost | resource | account number |
1 | 2 | 3 | 4 |
3 | 4 | 5 | 6 |
Thanks in advance
Hi @Armansson ,
The tool required is Union Tool.
Input: Tables given by you
Output:
Workflow:
Here is a resource on Union tool.
https://community.alteryx.com/t5/Interactive-Lessons/Blending-Data-with-Unions/ta-p/76632
Hope this helps 🙂
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
Hello,
Thanks for you reply.
is there any way to separate the merged data in following way? (I want the merged data to be separated under different headers in the same sheet, the header can be the name of incoming data into union tool, as below)
time | Cost | resource | account number |
#1 | |||
1 | 2 | 3 | 4 |
#2 | |||
3 | 4 | 5 | 6 |
Hi @Armansson ,
Here is a workflow for the task.
Output:
Workflow:
Hope this helps 🙂
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍