Data

Page tree

Versions Compared

Old Version 6

changes.mady.by.user Kathleen Church

Saved on

compared with

New Version Current

changes.mady.by.user Gabrielle O'Neal

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Include Page
Data Nav_T&O
Data Nav_T&O


Back to Knowledge Base

QuickSight: How To Create a Dataset Joining Two Existing Data Sources

There are times when you need to create a dataset in QuickSight that uses more than one data source.  This 'How Toto' will explain how to create a new dataset in QuickSight using two data sources.

Step-by-step guide

  1. After creating a Dataset dataset from one data source (details on how to do that are here), select the Add data button:. Add Data buttonImage Added
  2. Select which the relevant table(s) you want to added add to the join by by checking /or unchecking the box next to the table, then click Select:.
    Image RemovedImage RemovedAll users and groups selectionImage Added
  3. Inside the data pane, clicking on the two red buttons of the join will let you users specify what field(s) to join between those tables and join types (inner, left, right, or full join):Image RemovedWhen you are finished, make sure you name your .

Join configurationImage Added

4. After selecting the joins,  name the dataset, pick SPICE (Super-fast, Parallel, In-memory Calculation Engine), then click Save

:Image RemovedYour

. 

SPICE option selectedImage Added

5. The saved dataset is now available for use in an Analyses

:

.

Image Removed

Lists of datasets.Image Added


HTML
<style>#title-text {
		display:none !important;
	}
.aui-navgroup-primary {  
                font-size: 1.25em;  
                font-weight:  bold;  
    }  
.page-metadata-modification-info {
		display:none !important;
	}
</style>