Version: v2.4
JoinOnCommonColumns
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 |