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
Used extensions & nodes
Created with KNIME Analytics Platform version 4.7.1
Loading ad hoc jobs
By using or downloading the workflow, you agree to our terms and conditions.