fj#

swordfish.function.fj()#

Return all rows from equi join together with rows that are not matched from either the left table or the right table.

Parameters:
  • rightTable (leftTable /) – The 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.