Combine two different arrays

raphael

• February 19, 2015 00:00

• Answered

Follow

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.

• 

  admin

  • February 25, 2015 13:29

  0

  Comment actions Permalink

  Hi Raphael,
  
  Please take a look on this post viewtopic.php?t=5590#p8836
  
  I hope that helps.
• 

  jurban

  • February 26, 2015 16:31

  0

  Comment actions Permalink

  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

Please sign in to leave a comment.