Combine two different arrays

CloverDX Platform
1

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.

2

Hi Raphael,

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

I hope that helps.

3

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