Merge Multiple Data Sources into a Single Dataset
Merging is not limited to cost/schedule. Any dataset that has an ID structure that corresponds with the activity IDs in the main dataset can be merged.
If the field headings in the XLS merge file correspond to field names in the Acumen file, they will be auto-mapped (merged).
To create a merge file, complete the following steps:
- Select the S1 // Projects tab.
- In the Projects pane, select the project or snapshot file to which you want to merge data.
- Right-click the project and select Merge with Excel File.
- On the Add File dialog box, select the Excel file and click Open.
-
On the Excel Merge dialog box:
- Select the worksheet you want to merge with the project.
- Select the column that matches the ID field in your project.
- Click OK.
- In the Import group, click the Import All Projects down arrow and select Import Project to complete the merge.
Parent Topic: S1 // Projects Tab Procedures