Print Page - How to join merge the data of two lists with same fields into a single list

Title: How to join merge the data of two lists with same fields into a single list
Post by: semsel on 23 Oct 2012 07:02:02 AM

I have two lists say

List 1:

EmpCode | EmpName
1001 Smith
1002 Berry

List 2:

EmpCode | EmpName
1003 Joan
1004 Mini

Now I want to display it as :

EmpCode | EmpName
1001 Smith
1002 Berry
1001 Smith
1002 Berry

Is there any way?

Title: Re: How to join merge the data of two lists with same fields into a single list
Post by: squish88 on 16 Nov 2012 11:56:58 AM

Assuming you meant that you wanted to display this:

EmpCode | EmpName
1001 Smith
1002 Berry
1003 Joan
1004 Mini

You could use a union.

Title: Re: How to join merge the data of two lists with same fields into a single list
Post by: ravimahazan84 on 21 Nov 2012 02:28:53 AM

simply use the union if there is no common column in which u can join these two tables

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: semsel on 23 Oct 2012 07:02:02 AM