Can not create join: All sheets of 'JoinPair{parsedata![dma_name]<=>work_MultiZipCode_GetMultiZC![DMA]}' do exist in previous pairs

Follow

Sharon

• July 09, 2019 21:56

Hi,

Can you kindly explain what this error means?  I am trying to create a joined sheet.  Similar posts do not reveal an answer, unfortunately.

 

Thank you in advance!

0

• 

  Konsta Danyliuk

  • July 10, 2019 12:47

  Hello Sharon.
  This exception might occur if one tried to use join dialog incorrectly.

  When one wants to join Sheet1 and Sheet2, it uses a simple TWO_MEMBER_JOIN. Here is a JSON definition of this operation.

  sheetDefinition: {
  joinCategory: "TWO_MEMBER_JOIN",
  joinPairs: [
  {
  joinType: "OUTER_LEFT",
  sheet1: "Sheet1",
  sheet2: "Sheet2",
  joinColumns1: [
  "B"
  ],
  joinColumns2: [
  "B"

  

  When there is a need to join Sheet1 and Sheet2 on more than one column, it would be the same TWO_MEMBER_JOIN, but with more join columns.

  sheetDefinition: {
  joinCategory: "TWO_MEMBER_JOIN",
  joinPairs: [
  {
  joinType: "OUTER_LEFT",
  sheet1: "Sheet1",
  sheet2: "Sheet2",
  joinColumns1: [
  "B",
  "C"
  ],
  joinColumns2: [
  "B",
  "C"

   

  

   

  If it is required to join more than one Sheet, one should use MULTI_JOIN. So if its needed to join Sheet1, Sheet2 and Sheet3, at the first step, one should join Sheet1 and Sheet2, then at the second step, join Sheet2 and Sheet3.

  sheetDefinition: {
  joinCategory: "MULTI_JOIN",
  joinPairs: [
  {
  joinType: "OUTER_LEFT",
  sheet1: "Sheet1",
  sheet2: "Sheet2",
  joinColumns1: [
  "B"
  ],
  joinColumns2: [
  "B"
  ]
  },
  {
  joinType: "OUTER_LEFT",
  sheet1: "Sheet2",
  sheet2: "Sheet3",
  joinColumns1: [
  "C"
  ],
  joinColumns2: [
  "C"
  ]

   

  For example, if you will try to use MULTI_JOIN to join Sheet1 and Sheet1 twice, you will get  All sheets of JoinPair do exist in previous pairs exception. In this case, you should use TWO_MEMBER_JOIN with two joinColumns.

  0

  Comment actions Permalink
• 

  Sharon

  • July 10, 2019 14:59

  
  Thank you, Konsta.

  I am only using the file -> Join option and yes, trying to select multiple columns.  I suppose this is the equivalent of your explanation of using a MULTI_JOIN to join Sheet1 and Sheet1 twice, you will get  All sheets of JoinPair do exist in previous pairs exception.

  If in this case a TWO_MEMBER_JOIN should be used, and file -> join does not give this option, then where is this specified?  I am new to datameer and have not yet seen where to specify a coded version of a join.

   

  Thank you,

  Sharon

   

   

  0

  Comment actions Permalink
• 

  Sharon

  • July 10, 2019 15:20

  Just as an aside, the documentation does state to use a multi join with multiple columns but does not state anything about a TWO_MEMBER_JOIN.  Can you please advise?

   

  Thanks again,

  Sharon

  Creating a Join From Multiple Columns
  

  Creating a multi join or multi-key join is easy with Datameer. With the multi-key join, you can specify multiple columns from two different worksheets and join the data together.

  0

  Comment actions Permalink
• 

  Konsta Danyliuk

  • July 10, 2019 15:25

  Hello Sharon.

  Do you think it would be better if we move this discussion into a support ticket? If you will log in to support.datameer.com with your corporate email, you should be able to submit a new ticket. As soon as we get it, I would be happy to continue to assist you.

  0

  Comment actions Permalink
• 

  Sharon

  • July 10, 2019 15:40

  Hi Konsta,

  I have done that, and don't see the update.  I am available now if you can do...

   

  Thank you very much,

  Sharon

  0

  Comment actions Permalink

Please sign in to leave a comment.