Page 1 of 1

Combine two different arrays

Posted: Thu Feb 19, 2015 1:16 pm
by raphael
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.

Re: Combine two different arrays

Posted: Wed Feb 25, 2015 2:29 pm
by kubosj
Hi Raphael,

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

I hope that helps.

Re: Combine two different arrays

Posted: Thu Feb 26, 2015 5:31 pm
by jurban
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