Questions? We have answers.

Search

  1. MindBridge: English (US)
  2. Get started
  3. Import files
  4. File manager

Merge multiple files onto one sheet

  • Updated

Summary

When you import a file for analysis, MindBridge leverages the data found on the first sheet. If multiple sheets of data need to be analyzed, you can split out the required sheets from the original file, then merge them into a new concatenated file so all of the required data appears on the new file's first sheet.

Learn how to merge multiple files in MindBridge's File manager.

Note: To access the File manager, you must first create an engagement.

Go to the File manager

Within an engagement, use the MindBridge sidebar to go to the File manager ( File manager icon ). 

Merge files

Select files to merge

Note: In order to merge files, the data within the files must be in an ungrouped format, and the file must contain only 1 worksheet. If a file with more than 1 sheet is selected, the Merge option will be disabled.
  1. Check the boxes next to the files you want to merge. Upon your first selection, a blue bulk actions bar appears.
  2. Open the Actions menu.
  3. Select Merge*. You will go to the first step in the merge workflow ("Arrange files").

Step 1: Arrange files

The files will be merged in the order in which they appear here.

  1. Use the arrows ( Up arrow icon / Down arrow icon ) in line with the desired file to change its position in the list.
  2. When you are satisfied, select Next to go to the next step.

Optional step: Add files

If you want to add additional files to the merge, they can be added in this step.

  1. Select Add files.
  2. Check the boxes next to the file(s) you want to include in the merge.
  3. When you are satisfied, Add the files.
Note: Files that have already been added cannot be removed during this step.

Step 2: Select columns

MindBridge scours the files you selected to determine which file has the most columns. The columns from that file are displayed in order of appearance beneath "Column name" and can be pared down as needed.

  1. Use the checkboxes on the left side of each row to select which columns to include in the final merged file, or select the checkbox next to "Column name" to select them all.
  2. When you are satisfied, select Next to go to the next step.

Step 3: Match columns

Each section corresponds to a column you selected in the previous step. MindBridge scans each file and matches up columns with identical names automatically. Columns that could not be matched automatically are flagged as Unmatched and will require your attention.

Note: Columns can only be matched once.
  1. Use the arrow next to the column name to expand the section.
    • The source column appears first and cannot be adjusted.
    • Columns matched automatically display the column name in the menu.
    • Unmatched columns are highlighted.
  2. Open the highlighted menu.
  3. Select the correct column from the list.
  4. When you are satisfied, select Next to go to the next step.
  5. Optionally, if you have unmatched columns, a confirmation window will appear. If you do not want to include the unmatched columns in the new file, select Confirm to proceed.
Note: Leaving columns unmatched will result in data missing from the final file.

File manager Merging multiple files

Step 4: File preview

This file preview displays the first 5 rows of each file selected for merging.

  1. Review the file preview to ensure that the correct columns were selected.
  2. When you are satisfied, select Next. A form window will appear.
  3. Enter a name for the merged file.
  4. When you are satisfied, Save your work. You will go back to the File manager and the new file will appear with the Modified status.

This new file can now be imported into your desired analysis.

Anything else on your mind? Chat with us or submit a request for further assistance.

Was this article helpful?