S
Simpleasyty
Help Center — Join tables
GETTING STARTED
IntroductionInstall the appQuick startRuns on Atlassian
SIMPLE TABLE
PasteAttachmentsFile uploadJoin tablesPage PropertiesConfluence ContentJira Issues
TABLE WITH BODY
Native Confluence tables
DATA STORAGE
Data residencyNo data egressSave table data
REUSE TABLES
Table Excerpt / Include
DISPLAY
SearchFiltersSortingGroupingRow numbersFull screen modeDownload tableConfidential labelRovo
COLUMNS
ReorderingRename headingHideIncognito modeText appearanceColumn colorsData typeGrouping aggregationFooter aggregationCalculated columnExpression functionsNested JSON fieldsDelete column
PIVOT TABLES
Overview
FORMATTING
Layout & spacingTable colorsTable heightPagination

Join tablesAvailable in 8.0.0

Combine two published Simple Tables on the same Confluence page into one live table, without manually copying rows.

SIMPLE TABLE MACRO

How joins work

An Inner join shows matching rows only. A Left join keeps every row from the left table and adds matching data from the right. For example, connect projects to their owners using a shared ID.

Sources can be tables created with the Simple Table macro or the Simple Table with Body macro. Existing joins can also be used, provided they do not create a circular reference. The result supports sorting, filtering, grouping, calculated columns, and exports.

Create a join

First, publish at least two Simple Tables on the same page.

1

Choose the data source

Insert a Simple Table macro and choose Join Simple Tables as the data source.

2

Select the tables

Find the left and right tables in turn by page position and column names. Inspect the preview of each source.

3

Set the relationship

Choose the matching column from each table and select Inner join or Left join.

4

Configure the result

Review the selected columns and preview, configure the table, and publish the page.

Matching values

Empty values do not match. Values must have the same type: the number 1 does not match the text "1". Multiple matching rows produce multiple result rows. If a matching column is removed, reconfigure the join.