Forum H2 Join
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
Nodes
- Column Filter Configuration2 ×
- DB Writer2 ×
- Extract Column Header2 ×
- GroupBy2 ×
- Merge Variables2 ×
- Show all 20 nodes