Union Equivalent in Clover ETL Designer

yevad76

• March 11, 2014 00:00

• Answered

Follow

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

  • March 12, 2014 09:58

  0

  Comment actions Permalink

  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,
• 

  b__chuck

  • February 08, 2017 22:09

  0

  Comment actions Permalink

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

Please sign in to leave a comment.