Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Combining two resulting datasets

DylanBain
6 - Meteoroid

I have created a workflow that will pull the two biggest items by $ amount and randomly select two additional selection. I would like to combine those outputs into a single file to output. Anyone i have an idea on how to do this? Sample data below. Thanks!

 

Source #1  
#NAMEJob Title EDITTransaction #$
1DougDude20     1.00
2JohnDude-in-charge1125     2.25
3SteveSuper Dude3030     2.25
     
Source #2  
#NAMEJob Title EDITTransaction #$
4DougDude5568     5.00
5JohnDude-in-charge1002     6.25
6SteveSuper Dude303     1.25
     
Result   
#NAMEJob Title EDITTransaction #$
1DougDude20     1.00
2JohnDude-in-charge1125     2.25
3SteveSuper Dude3030     2.25
4DougDude5568     5.00
5JohnDude-in-charge1002     6.25
6SteveSuper Dude303     1.25
3 REPLIES 3
BrandonB
Alteryx
Alteryx

You should be able to bring both of these together using a Union tool

BrandonB
Alteryx
Alteryx

union.png

DylanBain
6 - Meteoroid

Didn't look right the first time I sent it through. Now I feel silly. Thanks!

Labels