topic better way to perform an equivalent of UNION in SQL in PDI? in Integration and Testing https://community.developer.cybersource.com/t5/Integration-and-Testing/better-way-to-perform-an-equivalent-of-UNION-in-SQL-in-PDI/m-p/78745#M49490 <P><SPAN>hello </SPAN><SPAN>I am trying to see the best way to perform a UNION in PDI. I have 3 table input steps with 3 different queries that gives me two columns in the results like the Date and Tickets. I would like to combine the results from the 2 or more streams and add the values.</SPAN><BR /><BR /><SPAN>I am currently using the Dummy step and then using the Group by step to add the values. I am not sure if there is a better way to do this instead of using the Dummy step and wondering if I can get any inputs on the same.</SPAN><BR /><BR /><SPAN>I also tried using the Multiway Merge Join and doing a FULL OUTER JOIN but this is giving me the following results: Date_1, Tickets_1, Date_2, Tickets_2, Date_3, Tickets_3 so not sure if I am doing it right.thx</SPAN></P> Fri, 24 Sep 2021 06:02:15 GMT Pedro20 2021-09-24T06:02:15Z better way to perform an equivalent of UNION in SQL in PDI? https://community.developer.cybersource.com/t5/Integration-and-Testing/better-way-to-perform-an-equivalent-of-UNION-in-SQL-in-PDI/m-p/78745#M49490 <P><SPAN>hello </SPAN><SPAN>I am trying to see the best way to perform a UNION in PDI. I have 3 table input steps with 3 different queries that gives me two columns in the results like the Date and Tickets. I would like to combine the results from the 2 or more streams and add the values.</SPAN><BR /><BR /><SPAN>I am currently using the Dummy step and then using the Group by step to add the values. I am not sure if there is a better way to do this instead of using the Dummy step and wondering if I can get any inputs on the same.</SPAN><BR /><BR /><SPAN>I also tried using the Multiway Merge Join and doing a FULL OUTER JOIN but this is giving me the following results: Date_1, Tickets_1, Date_2, Tickets_2, Date_3, Tickets_3 so not sure if I am doing it right.thx</SPAN></P> Fri, 24 Sep 2021 06:02:15 GMT https://community.developer.cybersource.com/t5/Integration-and-Testing/better-way-to-perform-an-equivalent-of-UNION-in-SQL-in-PDI/m-p/78745#M49490 Pedro20 2021-09-24T06:02:15Z