Merging Datasets
You can merge the values from one dataset into another.
![]() |
The Merge feature requires a license for advanced features. See Licensing Requirements for more information. |
To merge the dataset values:
- On the View Data window , click Merge Data in the source data entry.
- On the Merge Datasets window that appears, the KS6800A software shows "Merging data from <Source Dataset> to <Pick Destination Dataset>". You can :
- Optionally, click the <Source Dataset> name (in this example, NewDataset1) to choose another dataset to be the source.
- Click <Pick Destination Dataset> to choose a dataset, where all data from the Source Dataset will be merged into.
In either case, the Pick a Dataset pop up dialog appears.
- Click the dataset name you wish to use as Source or Destination. Use the Filter... field to narrow down the dataset name from a long list of datasets.
Note that the selected dataset name replaces the option (Source or Destination) you selected earlier.
The number of rows from the source dataset that shall be merged to the Destination Dataset is displayed.
In the Fields area, the information is displayed in several rows after the KS6800A software checks both the Source and Destination datasets for same field names (with the same data type).
- If this condition matches, the statement "Will merge <field_name> into existing field <field_name>" is displayed with the
icon, for each field.
- If this condition does not match, the statement "Will merge <field_name> into a newly created field <field_name>" is displayed with the
icon, for each field.
- Optionally, for each row displayed, you may click (change) to choose another field from the destination dataset where you want the values from the field in the source dataset be merged into. Else, skip to step 7.
The Pick a field dialog appears. Here you can:
- Enter a new field name in the Name text box and click create.
- Click the Field name you wish to merge the Destination. Use the Filter field to narrow down the field name from a long list.
Note that the KS6800A software displays only such existing destination field names here, whose data type (integer, float, boolean, string, timestamp) matches with that of the source field.
- Click Close to return to Merge Datasets window.
- Click Start Merge.
The fields (and the corresponding values) from the source dataset are merged into the destination dataset and the View Data window is displayed, along with a notice pop-up informing about the merge. You shall notice an increase in the number of rows in the dataset you had selected as destination.