Join data in workbooks
Joins combine data from multiple sources based on matching columns.
This article covers how to create joins in workbooks.
To understand joins in datasets, see Join data in datasets.
Join data sources
Before you start: This action is only available in edit mode. To begin editing, click Edit in the top right corner of the page; see Workbook lifecycle.
Open the workbook's ADD NEW panel.
- Under DATA ELEMENTS, click to select your desired element type: TABLE, VIZ, or PIVOT TABLE.
It's time to select a data source.
Open the NEW tab.
- Select JOIN.
This opens the Select Source modal.
- Select a source from the left panel.
The prompts that follow depend on your selected source type.
- Once your source's preview has loaded, click Select.
This opens the Create join page.
- Joins require two or more sources.
To begin adding your second source, click the plus (+) button next to SOURCES in the left panel.
- Repeat steps 5 & 6.
- Select a Join type. What are join types?
- Select your Join keys.
Note: In some cases, you'll want to define multiple pairs of join keys.
On the right side of the page, you'll see match rates for your proposed join.
- [optional] To join an another source, repeat steps 7 – 10.
- When ready, click Preview output.
- Review your join's preview, and make any wanted changes to included columns.
- Click Done.
Your new element appear in the workbook.
One interesting use case is to perform a calculated join on a field extracted from JSON. You can use the modal to extract the JSON, and then copy the resulting formula from the formula bar.