Combine Individual Workbooks

3 followers
0
Avatar

Is there any way to combine workbooks? Trying to combine two separate workbooks with different data sets.

Fred Pepmiller

1 comment

  • Avatar
    Anthony Aliffi

    Hi Fred,
    It sounds like you're looking to Join the datasets/workbooks.
    One thing to keep in mind, is that you'll want something that is consistent between the data sets (what we call a Join Key), so that it knows how to appropriately line up the records. A good example of this would be a customer number, linking transitions, with user details.

    First, you'll want to add each dataset to a workbook. This can be accomplished via File -> Add Data (you can even add an existing workbook).
    Next, you'll want to open the Join Dialog via Data -> Join t , which will allow you to select the join type, and the column that contains the Join Key.

    This process can be reviewed in our documentation, with great step-by-step images, from the following link
    https://documentation.datameer.com/documentation/current/Joining+Data

    Hope this helps!

    Anthony

    0
Please sign in to leave a comment.