# Combine two different arrays

**URL:** <https://forum.cloverdx.com/t/combine-two-different-arrays/1583>\
**Category:** CloverDX Platform\
**Created:** [February 19, 2015, 12:00am UTC](https://forum.cloverdx.com/t/combine-two-different-arrays/1583 "2015-02-19T00:00:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![raphael](https://avatars.discourse-cdn.com/v4/letter/r/edb3f5/32.png) [@raphael](https://forum.cloverdx.com/u/raphael)\
**Post date:** [February 19, 2015, 12:00am UTC](https://forum.cloverdx.com/t/combine-two-different-arrays/1583/1 "2015-02-19T00:00:00Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![David\_Hlidek](https://avatars.discourse-cdn.com/v4/letter/d/58f4c7/32.png) [@David\_Hlidek](https://forum.cloverdx.com/u/David_Hlidek)\
**Post date:** [February 25, 2015, 1:29pm UTC](https://forum.cloverdx.com/t/combine-two-different-arrays/1583/2 "2015-02-25T13:29:46Z")

</div>

Hi Raphael,

Please take a look on this post [viewtopic.php?t=5590#p8836](http://forum.cloveretl.com/viewtopic.php?t=5590#p8836)

I hope that helps.

---

<div class="post-metadata">

**Author:** ![jurban](https://avatars.discourse-cdn.com/v4/letter/j/cc9497/32.png) [@jurban](https://forum.cloverdx.com/u/jurban)\
**Post date:** [February 26, 2015, 4:31pm UTC](https://forum.cloverdx.com/t/combine-two-different-arrays/1583/3 "2015-02-26T16:31:07Z")

</div>

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