Skip to main content

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​

PortTypeTakes
lefttableone edge
righttableone edge

Parameters​

ParameterKindDefaultChoices
howmenu"inner"inner, left, cross
leftKeycolumn""
rightKeycolumn""
leftKey2column""
rightKey2column""
prefixstring"r_"

Outputs​

PortType
outtable

Details​

  • Category: Tables
  • Operator: join