ej

swordfish.function.ej()

Return only the rows that have equivalent values for the matching columns.

Parameters:

• leftTable/rightTable (Constant) – A table to be joined.

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

• rightMatchingCols (Constant) – 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.

• leftFilter/rightFilter (Constant) –

  A condition expression used as filter conditions for the columns in the left and right tables. Use “and” or “or” to join multiple conditions.

  Note

  If parameter leftTable / rightTable is specified as a dimension table or partitioned table, parameters leftFilter and rightFilter must not be specified.