Concatenate permutations between two columns

Follow

Peter Han-Grassman

• September 08, 2016 20:10

I need to combine every combination of two columns into another column.  I know I can accomplish this in Excel, but need to be able to replicate this in Datameer.  Are there suggestions on how to accomplish this?  

Example below from Excel: 

http://stackoverflow.com/questions/29741469/every-possible-combination-of-the-contents-of-2-columns-in-excel

 

0

• Official comment

  

  Joel Stewart

  • September 08, 2016 21:05

  Thanks for the question Peter! This is known as a "Cartesian Product" and the details for implementing it are available in this post: https://datameer.zendesk.com/hc/en-us/community/posts/202328844-Cartesian-Product-one-paired-with-many 

  Comment actions Permalink

Please sign in to leave a comment.