Hi @rds , As @jpollet suggests, the cross joiner method is a possible way to achieve this with the standard KNIME nodes. You may be interested in an alternative method, in the form of a component which utilises the H2 database node to provide this functionality…
Joining with custom conditions.knwf (205.4 KB)
You can specify the where clause using H2 sql, and refer to the two input tables as “t1” and “t2”. It is necessary to include any column names in double quotes to preserve their case, otherwise H2 will assume the names are upper case which may cause the query to fail.
e.g.
substr(t1."Code",2)
LIKE '%'||t2."Reference" ||'%'
I have other “joiner components” in this demonstration workflow: