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

JoinUsingColumn

This node joins the incoming dataframes on a joinCol

Input

This node takes in 2 DataFrames as input and produces one DataFrame as output

Output

The output DataFrame is the result of joining the 2 incoming DataFrames on the join column

Type

join

Fields

NameTitleDescription
joinColJoin Columncolumn on which to join

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

Refresh the Schema tab.

Output

txiditem_iddatepy_idamountpy_idpay_typeamount
100100012019-09-200110001credt_card60
100100012019-09-200110001redme_coupon20
100100012019-09-200110001redme_emp_offer20
100200012019-09-200210002credt_card160
100200012019-09-200210002redme_coupon40