Union Equivalent in Clover ETL Designer

Support/help with CloverETL implementation problems

yevad76
Posts: 1
Joined: Tue Mar 11, 2014 3:31 pm

Union Equivalent in Clover ETL Designer

Postby yevad76 » Tue Mar 11, 2014 3:33 pm

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,

imriskal
Posts: 383
Joined: Wed Aug 15, 2012 8:18 am

Re: Union Equivalent in Clover ETL Designer

Postby imriskal » Wed Mar 12, 2014 10:58 am

Hi,

Of course there is, you can use SimpleGather component. For more details, see http://doc.cloveretl.com/documentation/ ... ather.html

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

Regards,
---
Lubos Imriska
CloverCARE Support
CloverETL | Rapid Data Integration

Visit us online at http://www.cloveretl.com
How to speed up communication with CloverCARE support

b__chuck
Posts: 1
Joined: Tue May 03, 2016 5:47 pm

Re: Union Equivalent in Clover ETL Designer

Postby b__chuck » Wed Feb 08, 2017 11:09 pm

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