Skip to main content
info
This documentation is for version v2.3 of the product.
For the latest version(v2.7) documentation click here
Version: v2.3 print this page

JoinUsingColumns

This node joins the incoming dataframes on 1 or more columns

Input

It takes in 2 DataFrames as input and produces one DataFrame as output by joining on the specified columns

Output

The output DataFrame produced as a result of joining the incoming DataFrames on the specified columns

Type

join

Fields

NameTitleDescription
joinColsJoin ColumnsSpace separated list of columns on which to join
joinTypeJoin TypeType of Join
outputColNamesOutput Column NamesName of the Output Columns
outputColTypesOutput Column TypesData Type of the Output Columns
outputColFormatsOutput Column FormatsFormat of the Output Columns
whereClauseWhere Clausewhere condition after join function

Input1

txiditem_iddatepy_idamount
100100012019-09-2001100
100200012019-09-2002100

Input2

py_idtxidpay_typeamount
011001credt_card60
011001redme_coupon20
011001redme_emp_offer20
021002credt_card160
021002redme_coupon40

Parameters

NameValue
Join Columntxid, py_id
Join Typeinner
Where Clausepay_type = 'credt_card'

Refresh the Schema tab.

Output

txidpy_iditem_iddateamountpay_typeamount
10010100012019-09-20100credt_card60
10020200012019-09-20100credt_card160