Logic for combination

gd · Post by gd » Tue Mar 27, 2007 3:05 am

Hi All,
I have the following input:

Col1 Col2
1 US
1 UK
1 HK

I want to have output with all combinations as follows:

Col1 Col2 Col3
1 US UK
1 US HK
1 UK HK

Similarly, if I have 4 rows in input then I will have 6 rows in output. Please suggest any method.

Regards,
Gaurav

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Mar 27, 2007 3:42 am

Even though I am not sure why you need that, a join must meet your requirement.

kumar_s · Post by **kumar_s** » Tue Mar 27, 2007 6:10 am

Routine would be simple to attain. If you plan to use the existing stages, you need to do either do join or lookup to get a cartesian product. And using transformer, you need to eliminate the rows like US US, UK UK HK HK.
And you need to check for the previuous row values and eliminate UK US, and HK US, HK UK.

ray.wurlod · Post by **ray.wurlod** » Tue Mar 27, 2007 8:13 am

"Fork join" design. Copy stage to generate two copies of the input, then Join stage to re-join them based on key.