Merging datasets

This section of the Graphite Note user documentation will guide you through the process of merging multiple datasets into one.

Merging datasets allows you to combine data from different sources or related data for more comprehensive analysis.

Steps to Merge Datasets

1. Select Merge Dataset from the Menu

To begin the process, navigate to the main menu and select the "Merge Dataset" option. This will open a new window where you can start the merging process.

2. Enter Name and Description of the Merged Dataset

In the new window, you will see fields to enter the name and description of your new merged dataset. This helps you identify the purpose of the merged dataset for future reference. You can also add optional tags to further categorize your dataset.

3. Select Datasets to Merge and Define the Type of Join

Next, you will select the first dataset you want to merge from the dropdown menu. Repeat this step to select the second dataset.

After selecting your datasets, choose the type of join you want to perform: inner, left, right, or outer. The type of join determines how the datasets are combined based on the values in the key columns.

Then, select the key columns on which to merge the datasets. These are the columns that the datasets have in common and will be used to align the data.

4. Select Columns for Your New Merged Dataset

Now, you will choose which columns you want to include in your new merged dataset. You can select columns from either or both of the original datasets.

Once you've selected your columns, you can use the "Test This Merge" button to preview the merged rows. This allows you to check that the datasets are merging as expected before finalizing the process.

5. Create Your Merged Dataset

If you're happy with the preview of the merged dataset, click the "Create" button to finalize the merge. Your new merged dataset will now be available for use in your Graphite Note projects.

Remember, merging datasets is a powerful tool for combining and analyzing data in Graphite Note. By following these steps, you can easily merge datasets to gain new insights from your data.