Combine two different arrays

Support/help with CloverETL (4.9) and CloverDX (5.0 or newer) implementation problems

raphael
Posts: 3
Joined: Wed Jan 21, 2015 2:28 pm

Combine two different arrays

Postby raphael » Thu Feb 19, 2015 1:16 pm

Hi,

I have got an issue in combining two arrays with different number of records.for eg lets say one of the array contains 3 properties(say "kraftmaid","cabinet","doors") and the other array contains 10 products ("000","001","002",... "009").I want to combine each property with each product.ie the final array will have 30 products with two columns like
property product
kraftmaid 001
kraftmaid 002
kraftmaid 003
kraftmaid .
. .
. .

doors 001
doors 002
doors 003
doors 004
. .
. .
.
cabinet 001
cabinet 002
cabinet 003
cabinet 004
cabinet 005
. .
. .
. .


Thanks in advance.

kubosj
Posts: 372
Joined: Thu Jan 12, 2012 9:10 am

Re: Combine two different arrays

Postby kubosj » Wed Feb 25, 2015 2:29 pm

Hi Raphael,

Please take a look on this post viewtopic.php?t=5590#p8836

I hope that helps.
Jaroslav Kubos
CloverCARE Support
CloverETL | Rapid Data Integration

Visit us online at http://www.cloveretl.com

jurban
Posts: 163
Joined: Fri Jul 20, 2007 9:25 am

Re: Combine two different arrays

Postby jurban » Thu Feb 26, 2015 5:31 pm

Hi Raphael,

in the upcoming CloverETL version 4.1.0 we'll have a new component CrossJoin, that will do exactly what you need.

Regards,
Jaro
Jaroslav Urban
CloverCARE Support
CloverETL | Rapid Data Integration

Visit us online at http://www.cloveretl.com