Workflow Demo Joiner Components

Workflow demonstrating the use of the Joiner Components

The joiners provide the following functionality:

Join Between: source column BETWEEN values in two lookup columns

Join Like: source column LIKE a wildcard pattern in a lookup column

Join Contains: source column contains a value in a lookup column (lookup is substring of source)

Join Reexp_Like: source column matches a regular expression pattern in a lookup column

Join Custom Condition: write a sql where clause to join two tables. This is useful for more complex/multiple conditions but requires basic sql syntax knowledge

Updated : 16 May 2023 - Additional of Join Contains Full Outer which returns three outputs Join, Left Unmatched and Right Unmatched