Documentationbreadcrumb arrow Learning pathsbreadcrumb arrow Transform databreadcrumb arrow Join by field
Transform data
15 min
Milestone 1
Value of transformations
1 min
Milestone 2
Plan transformations
2 min
Milestone 3
Add field from calculation
2 min
Milestone 4
Group by
1 min
Milestone 5
Filter data by values
2 min
Milestone 6
Join by field
2 min
Milestone 7
Organize fields by name
1 min
Milestone 8
Export transformations
1 min
Milestone 9
Destination reached!
1 min

Add a Join by field transformation

The join by field transformation is used to combine two or more data tables that share a common field. It’s similar to the SQL JOIN clause. Use this transformation to merge multiple results into a single table, enabling the consolidation of data from different queries. This is especially useful for converting multiple time series results into a single wide table with a shared time field.

To use the join by field transformation, complete the following steps:

  1. Open your dashboard in edit mode.

  2. Click Transformations tab and click + Add transformation button.

  3. Select or search for Join by field.

  4. Under Mode, select how you want your queries to be joined.

  5. Use the following table as a guideline for when to use the different modes.

    ModeWhen to use
    INNERWhen you want to combine the results from multiple queries into one result, and drop rows where a successful join cannot occur.
    OUTER (TIME SERIES)When you want to include all data from an inner join and rows where values do not match in every input.
    OUTER (TABULAR)When you want to join tables so that the result includes matched and unmatched rows from either or both tables.

  6. Under Field, select the field to be joined from the multiple tables.

  7. The transformation should be applied automatically. If not, click Refresh to verify the visualization looks as intended.

    The following image shows two queries joined by ID using the INNER join mode.

    Two data frames combined using the Join by field transformation

  8. Save your dashboard.

More to explore (optional)

At this point in your journey, you can explore the following paths:

Join by field

Filter data by values
page 7 of 10
Organize fields by name
page 7 of 10