Blend Data that You Added
You might have a project where you added multiple data sets. You can blend data from one data set with data from another data set.
When you add more than one data set to a project, the system tries to find matches for the data that’s added. It automatically matches external dimensions where they share a common name and have a compatible data type with attributes in the existing data set.
Data sets that aren't joined are divided by a line in the Data Panel of the project. If the project includes multiple data sets and if any aren't joined, then you'll see restrictions between data elements and visualizations. For example, you can't use the data elements of a data set in the filters, visualizations, or calculations of another data set if they're not joined. If you try to do so, you see an error message. You can match data elements of data sets that aren't joined in the Data Diagram of a project, or you can create individual filters, visualizations, or calculations for each data set.
You can specify how you want the system to blend your data.
- Add one or multiple data sets to your project. Confirm that you're working in the Prepare canvas.
- Go to the tabs at the bottom of the Prepare canvas and click Data Diagram. Alternatively, in the Data Panel, right-click and select Data Diagram.
- Click the number along the line that connects the external source to the newly loaded source to display the Connect Sources dialog.
- In the Connect Sources dialog, make changes as necessary.
- Click OK to save the matches.