sej#

swordfish.function.sej()#

Semantically equi join

Parameters:

  • leftTable (Constant) – The table to be joined.

  • rightTable (Constant) – The table to be joined.

  • matchingCols (Constant) – A string scalar/vector indicating matching columns.

  • rightMatchingCols (Constant, optional) – A string scalar/vector indicating all the matching columns in rightTable. This optional argument must be specified if at least one of the matching columns has different names in leftTable and rightTable. The joining column names in the result will be the joining column names from the left table, by default DFLT.

  • leftFilter (Constant, optional) – Condition expressions used as filter conditions for the columns in the left and right tables. Use “and” or “or” to join multiple conditions, by default DFLT.

  • rightFilter (Constant, optional) – Condition expressions used as filter conditions for the columns in the left and right tables. Use “and” or “or” to join multiple conditions, by default DFLT.

Returns:

A table.

Return type:

Constant

On this page