Mito's merge functionality can be used to combine datasets together horizontally. Merge looks for matches between the key column of the first sheet and the key column of the second sheet. Mito supports all of the most common merges.
Left Merge: Includes all rows from the first sheet and only matching rows from the second sheet. Includes all matches.
Right Merge: Includes all rows from the second sheet and only matching rows from the first sheet. Includes all matches.
Inner Merge: Only includes rows that have matches in both sheets.
Outer Merge: Includes all rows from both sheets, regardless of if there is a match in the other sheet.
Lookup Merge: Left join, but only includes the first match from the second sheet if there are multiple. Just like a Vlookup in Excel.
To merge datasets together, click on the merge icon in the Mito toolbar and then configure the merge task pane by:
Selecting the type of merge that you want to conduct.
Selecting the two Mito sheets that you want to merge together.
Choosing the Merge Keys to merge the datasets together on.
Using the columns toggles to determine which columns to keep from the previous two sheets.