Cartesian Product  one paired with many
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!

Official comment
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
Please sign in to leave a comment.
Comments
3 comments