S
Simpleasyty
Help Center — Join Tables
GETTING STARTED
IntroductionInstall the appQuick startRuns on Atlassian
ADD DATA
PasteAttachmentsFile uploadJoin TablesPage PropertiesConfluence ContentJira Issues
CONFLUENCE TABLES
Native Confluence tables
STORAGE & PRIVACY
Data residencyWhere table data goesAtlassian Store (Forge)Save table data
REUSE TABLES
Table Excerpt / Include
DISPLAY
SearchFiltersSortingGroupingRow numbersFull screen modeDownload tableConfidential labelRovo
CONFIGURE COLUMNS
ReorderingRename headingHideIncognito modeText appearanceColumn colorsData typeTextNumberDateBooleanEnumGrouping aggregationFooter aggregationCalculated columnExpression functionsNested JSON fieldsDelete column
APPEARANCE
Layout & spacingTable colorsTable heightPagination
PIVOT TABLES
Overview

ADD DATA

Join Tables

Combine two published Simple Tables on the same Confluence page into one live table.

Create a joined table

Join Simple Tables becomes available in Data when at least two other tables are published on this page.

  1. 1

    Publish two source tables

    Add two Simple Table or Simple Table with Body macros to the same page and publish it. The join cannot use itself as a source.

  2. 2

    Choose both tables

    Add another Simple Table macro and choose Join Simple Tables in Data. Search or browse the available tables, inspect their previews, and select the first and second source. They are identified by position on the page.

  3. 3

    Match columns and choose rows

    Select one matching column from each table. Same-name columns are suggested, but you choose the pair. Drag the source cards to change which table is first. Choose Matching rows only or All rows from first table.

  4. 4

    Review and publish

    Check the combined preview, choose Configure table, adjust the resulting columns, and publish. The second matching column is hidden initially; you can show it in Columns.

Note

If Join Simple Tables is unavailable, publish at least two other Simple Tables on this page, then reopen the macro editor.

Which rows appear?

The first table determines which rows can appear. Choose whether the result needs a match in both tables or should also keep unmatched rows from the first table.

Matching rows only (INNER)

Show a row only when its key appears in both tables.

: A + B

All rows from first table (LEFT)

Keep every row from the first table. Without a match, cells from the second table are empty.

: A + B / A

Example: orders and customers

Join both tables using Customer ID. One order has a customer match; the other does not.

Orders
Order 101 → customer A; order 102 → customer B.
Customers
Customer A → Acme. Customer B is not in this table.
Matching rows only (INNER)
Order 101 appears with Acme. Order 102 is omitted.
All rows from first table (LEFT)
Both orders appear. Order 102 has an empty customer name.

Matching and updates

Blank keys do not match, and a number does not match text with the same digits. Multiple matching rows produce multiple result rows. The join reads published source data, so publish source changes first. Existing joins may be sources, with safeguards against cycles and excessive nesting. Large results appear in batches of 500 rows with a provisional count and loading progress. The result is limited to 10,000 rows.