Cartesian Product - one paired with many

Comments

3 comments

  • Official comment
    Saurabh Agashe

    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

    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

    That did it! Hooah!

    0
    Comment actions Permalink

Please sign in to leave a comment.