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 | ||||
# | NAME | Job Title EDIT | Transaction # | $ |
1 | Doug | Dude | 20 | 1.00 |
2 | John | Dude-in-charge | 1125 | 2.25 |
3 | Steve | Super Dude | 3030 | 2.25 |
Source #2 | ||||
# | NAME | Job Title EDIT | Transaction # | $ |
4 | Doug | Dude | 5568 | 5.00 |
5 | John | Dude-in-charge | 1002 | 6.25 |
6 | Steve | Super Dude | 303 | 1.25 |
Result | ||||
# | NAME | Job Title EDIT | Transaction # | $ |
1 | Doug | Dude | 20 | 1.00 |
2 | John | Dude-in-charge | 1125 | 2.25 |
3 | Steve | Super Dude | 3030 | 2.25 |
4 | Doug | Dude | 5568 | 5.00 |
5 | John | Dude-in-charge | 1002 | 6.25 |
6 | Steve | Super Dude | 303 | 1.25 |
Solved! Go to Solution.
You should be able to bring both of these together using a Union tool
Didn't look right the first time I sent it through. Now I feel silly. Thanks!