Join
Match rows of two tables on key columns. Right-hand columns get the prefix.
Syntax
{ "id": "n1", "op": "join", "name": "join", "x": 0, "y": 0, "params": {} }
An edge into it ends at "targetPort": "left"; one out of it starts at "sourcePort": "out".
Inputs
| Port | Type | Takes |
|---|---|---|
left | table | one edge |
right | table | one edge |
Parameters
| Parameter | Kind | Default | Choices |
|---|---|---|---|
how | menu | "inner" | inner, left, cross |
leftKey | column | "" | |
rightKey | column | "" | |
leftKey2 | column | "" | |
rightKey2 | column | "" | |
prefix | string | "r_" |
Outputs
| Port | Type |
|---|---|
out | table |
Details
- Category: Tables
- Operator:
join