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

Name	Title	Description
joinCol	Join Column	column on which to join

Input1

txid	item_id	date	py_id	amount
1001	0001	2019-09-20	01	100
1002	0001	2019-09-20	02	100

Input2

py_id	txid	pay_type	amount
01	1001	credt_card	60
01	1001	redme_coupon	20
01	1001	redme_emp_offer	20
02	1002	credt_card	160
02	1002	redme_coupon	40

Parameters

Name	Value
Join Column	txid

Refresh the Schema tab.

Output

txid	item_id	date	py_id	amount	py_id	pay_type	amount
1001	0001	2019-09-20	01	100	01	credt_card	60
1001	0001	2019-09-20	01	100	01	redme_coupon	20
1001	0001	2019-09-20	01	100	01	redme_emp_offer	20
1002	0001	2019-09-20	02	100	02	credt_card	160
1002	0001	2019-09-20	02	100	02	redme_coupon	40