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.

Merging two outputs into one ouput data (excel file)

Armansson
5 - Atom

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: 

timecostresource account number
1234

 

Data 2: 

timecostresource account number
3456

 

I want to get here (Merged data): 

timecostresource account number
1234
3456

 

Thanks in advance

6 REPLIES 6
Emil_Kos
17 - Castor
17 - Castor

Hi @Armansson,

 

You need to use union tool.

 

Emil_Kos_0-1601884308045.png

 

Assaf_m
11 - Bolide

you can use the union tool

 

attached workflow for your reference

 

Assaf_m_0-1601884387009.png

 

atcodedog05
22 - Nova
22 - Nova

Hi @Armansson ,

 

The tool required is Union Tool.

Input: Tables given by you

Output:

atcodedog05_0-1601884688500.png

Workflow:

atcodedog05_1-1601884701613.png

 

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 😀👍

grazitti_sapna
17 - Castor

Hi @Armansson , with the help of union tool you can achieve the desired result.

 

grazitti_sapna_0-1601885677191.png

 

Thanks.

 

Sapna Gupta
Armansson
5 - Atom

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)

 

timeCost resource account number
    
#1   
1234
    
#2   
3456
atcodedog05
22 - Nova
22 - Nova

Hi @Armansson ,

 

Here is a workflow for the task.

 

Output:

atcodedog05_0-1601886802021.png

Workflow:

atcodedog05_1-1601886818898.png

 

Hope this helps 🙂

 

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

Labels