Turn one row into many.
The join action matches a row against the rows of a second table. The join writes one new row for each match into the table that you choose. The join uses no AI.
Example 1 · Expand Gift Set
Make a pick list from a gift set.
Order SO-10448 is one Tea Lover’s Gift Set. The join found the three items of that set in Bundle Contents. The join wrote one Pick List row for each item: the teapot, the green tea, two tins for each set, and the strainer.
Demo: the page of the join action Expand Gift Set. It runs on Orders, fans out over Bundle Contents where Bundle equals the input Bundle, and writes to Pick List, which has 9 rows. A pointer clicks Orders. Five new orders, rows 17 to 21, arrive. Row 18, SO-10448, GIFT-TEA, gets Pick Rows Written 3. The pointer opens Pick List: rows 10 to 12 are new, White Teapot 1 per set, Green Tea Tin 2 per set and Tea Strainer 1 per set.
What you set on a join.
These settings belong to the join. Inputs, outputs, columns and conditions work the same as on every action: see Actions.
The table to fan out over
Choose the table once. Each row there that matches gives one new row.
Match column
A reference column of that table. A row matches when this column is equal to the input. Or match every row of the table.
Values from each match
Choose which columns of the matched row go into which columns of the new row.
Values from the input
The values of the incoming row go into every new row, for example the order number.
Good to know.
Each run writes the rows again.
Use a condition so that the join runs once for each row. Here, Pick Rows Written must be empty.
No match, no rows.
If no row matches, the join writes nothing.
The join gives back counts.
Rows Written and Matched can come back into columns of the row.
Cost.
1 credit a run.
Security and compliance.
ISO 27001, SOC 2 Type 2 and GDPR are in progress. Oneleet shows the live status of each certification.
The agentic system builder
© 2026 Morphcloud