Module: Add Columns from a Separate
Source
|
|
| Lesson Objective | Learn how to add additional columns to your existing data set from an external source |
| Section | Description |
| Add Columns to an Existing Data Set | A discussion of data source options and how to match two data sets together by identifying matching columns. |
| Adding a Larger Data Set to a Smaller Data Set | Understanding that the initial data set opened in DecisionSite is the row delimiter. |
| Adding a Smaller Data Set to a Larger Data Set | Understanding the resulting empty values. |
| Merging Data Sets without a Continuous Overlap | Consideration of a solution involving the creation of an inclusive Key ID column to be opened as the initial data set. |
| Adding Columns with Replicate Key ID Rows | A discussion of the ability to merge with repeating values. Also, a caution about merging replicate values to a single row of an initial data set. |
| Multiple Data Columns Required to Create a Key ID | How to use multiple matching columns to create a unique Key ID for appropriate data merging. |
Print