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,
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,
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,
I used the Transformer Component called Merge. It essentially just stacks the two query result sets on top of one another.