Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Topic started by: aroravishal22 on 05 Mar 2012 06:41:03 PM

Title: How do I merge two datasets into One
Post by: aroravishal22 on 05 Mar 2012 06:41:03 PM
Hi, I am having problems in Merging two datasets into One. I can not use Joins as it is not joining on any fields nor Union as both datasets have different items. I used it in SSIS (SQL Server) as Merge Transformation. Any help woudl be greatly appreciated.
Thank
Title: Re: How do I merge two datasets into One
Post by: rockytopmark on 07 Mar 2012 11:52:24 AM
What data is in each dataset?  You say can't use UNION, so I assume these 2 datasets are very dissimilar in column construct.  How are you merging them in SSIS's Merge Transformation... is the end result more of a UNION or a Join there?

If there is no relationship between DataSet1 and DataSet2, then it would seem join query is out, and ultimately, you are looking to stack the datasets, which resembles a UNION in my thinking.

Any more details you can offer?
Text only | Text with Images