# Union Equivalent in Clover ETL Designer

**URL:** https://forum.cloverdx.com/t/union-equivalent-in-clover-etl-designer/1365
**Category:** CloverDX Platform
**Created:** [March 11, 2014, 12:00am UTC](https://forum.cloverdx.com/t/union-equivalent-in-clover-etl-designer/1365 "2014-03-11T00:00:00Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![yevad76](https://yyz1.discourse-cdn.com/flex007/user_avatar/forum.cloverdx.com/yevad76/32/131_2.png) [@yevad76](https://forum.cloverdx.com/u/yevad76)
#### Post date: [March 11, 2014, 12:00am UTC](https://forum.cloverdx.com/t/union-equivalent-in-clover-etl-designer/1365/1 "2014-03-11T00:00:00Z")

</div>

Hi,

I’m trying to union two sets of data coming from two different sources. Is there a way to union the data as opposed to join them?

Thanks,

---

<div class="post-metadata">

### Author: ![imriskal](https://avatars.discourse-cdn.com/v4/letter/i/b38774/32.png) [@imriskal](https://forum.cloverdx.com/u/imriskal)
#### Post date: [March 12, 2014, 9:58am UTC](https://forum.cloverdx.com/t/union-equivalent-in-clover-etl-designer/1365/2 "2014-03-12T09:58:04Z")

</div>

Hi,

Of course there is, you can use SimpleGather component. For more details, see [http://doc.cloveretl.com/documentation/ … ather.html](http://doc.cloveretl.com/documentation/UserGuide/topic/com.cloveretl.gui.docs/docs/simplegather.html)

If you want to preserve even the DISTINCT function of UNION, you can use Dedup component after the SimpleGather.

Regards,

---

<div class="post-metadata">

### Author: ![b\_chuck](https://avatars.discourse-cdn.com/v4/letter/b/e47774/32.png) [@b\_chuck](https://forum.cloverdx.com/u/b_chuck)
#### Post date: [February 8, 2017, 10:09pm UTC](https://forum.cloverdx.com/t/union-equivalent-in-clover-etl-designer/1365/3 "2017-02-08T22:09:20Z")

</div>

I used the Transformer Component called Merge. It essentially just stacks the two query result sets on top of one another.