Joiner Components
This directory contains 20 workflows.
Join Between
Joins two tables based on a selected column value in the TOP input table being between the values in the BOTTOM input table 12 November 2022 @takbb Brian Bates
Join Contains
Joins two tables based on a selected column value in the TOP input table containing within it, a value in the BOTTOM input table. (i.e. the value in the […]
Join Contains Full Outer
Joins two tables based on a selected column value in the TOP input table containing within it, a value in the BOTTOM input table. (i.e. the value in the […]
Join Custom Condition
Joins two tables: t1 the TOP input table and t2 the BOTTOM input table Specify the columns to be returned using the column filters. Specify the […]
Join Custom Condition - indexed
Joins two tables: t1 the TOP input table and t2 the BOTTOM input table Specify the columns to be returned using the column filters. Specify the […]
Join Custom Condition (3 way)
Joins THREEtables: T1 T2 T3 (in order of the input ports from top to bottom) Specify the condition, using SQL (H2 Database syntax) e.g. t1."id" = […]
Join Custom Condition (4 way)
Joins FOUR tables: T1 T2 T3 T4 (in order of the input ports from top to bottom) Specify the condition, using SQL (H2 Database syntax) e.g. t1."id" = […]
Join Like
Joins two tables based on a selected column value in the TOP input table matching a Wilcard pattern contained in the BOTTOM input table. Standard SQL […]
Join Like Full Outer
Joins two tables based on a selected column value in the TOP input table matching a Wilcard pattern contained in the BOTTOM input table. Standard SQL […]