Version: v2.5
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
Name | Title | Description |
---|---|---|
joinCols | Join Columns | Space separated list of columns on which to join |
joinType | Join Type | Type of Join |
outputColNames | Output Column Names | Name of the Output Columns |
outputColTypes | Output Column Types | Data Type of the Output Columns |
outputColFormats | Output Column Formats | Format of the Output Columns |
whereClause | Where Clause | where condition after join function |
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, py_id |
Join Type | inner |
Where Clause | pay_type = 'credt_card' |
Refresh the Schema tab.
Output
txid | py_id | item_id | date | amount | pay_type | amount |
---|---|---|---|---|---|---|
1001 | 01 | 0001 | 2019-09-20 | 100 | credt_card | 60 |
1002 | 02 | 0001 | 2019-09-20 | 100 | credt_card | 160 |