Join DataTable
Join DataTable
Section titled “Join DataTable”Type: join-datatable · Package: DataTable Activities v1.0.0 · Output: DataTable
Combines two DataTables into a single one, matching their rows by a common column (a key). It’s like a JOIN in SQL or a BUSCARV (VLOOKUP) in Excel: it allows you to enrich one table with data from another — for example, join the sales with the catalog of customers to have the name and email next to each sale.
How it works
Section titled “How it works”Matches each row in the left table (left) with those in the right (right) that have the same value in the on column (which must exist in both). The type parameter decides what happens to unpaired rows:
inner(default): Only keeps rows that have a partner in both tables.left: Keep all rows on the left; Those without a partner on the right are left with those empty columns.
Required parameters
Section titled “Required parameters”| Parameter | Editor | Description |
|---|---|---|
left | expression | The left DataTable. |
right | expression | The right DataTable. |
on | text | Name of the common column to join by (must exist in both). |
Optional parameters
Section titled “Optional parameters”| Parameter | Editor | Description |
|---|---|---|
type | list | Union type: inner (def.) · left. |
Output
Section titled “Output”Returns a DataTable with the columns from both tables combined.
Example
Section titled “Example”Join sales with customer data by column ClienteId:
Join DataTable left = = ventas right = = clientes on = "ClienteId" type = left → output: ventasCompletasRelated activities
Section titled “Related activities”- Rename Column — match the name of the key column.
- Filter DataTable — narrow before or after join.