Cartesian Product - one paired with many

Follow

Saurabh Agashe

• April 16, 2015 18:26

How do I turn a list of items into a paired list with other set values? For example,

12345

54321

into

12345 1

12345 2

12345 3

54321 1

54321 2

54321 3

This is called a Cartesian Product and can be the bane of those learning joins in SQL, however, I cannot seem to make Datameer give me a Cartesian product even though I want it! So I have a list of accounts in one table and a list of subaccounts in another table and want to make the Cartesian product join of each account to all subaccounts.

Thanks for any help!

0

• Official comment

  

  Saurabh Agashe

  • April 16, 2015 18:29

  It does indeed require a static Join Key to make this happen, as Frances indicated. To do so, add a 1 into the Formula Bar to create your static value column.

  Then use an Inner Join on your JoinKey column, hiding the JoinKey columns, as you see fit.

  And you end up with two columns with all of the values as Cartesian products.

  I hope this answers your question!

  Comment actions Permalink
• 

  Saurabh Agashe

  • April 16, 2015 18:26

  I know this is possible in Datameer by creating a false join key. You can do this by simply writing a 1 in the end column of each of the sheets giving it a commonality. Let me take a look at your sample data, though, and confirm that it's what you're asking for.

  0

  Comment actions Permalink
• 

  Saurabh Agashe

  • April 16, 2015 18:36

  That did it! Hooah!

  0

  Comment actions Permalink

Please sign in to leave a comment.