just a suggestion to Knime developers to enhace the joiner node to be more flexible (like SAS DI):
I think it would be nice to add logic operators (not only AND) and parenthesis between join conditions in order to obtain more complex data merging…, am I wrong?
ID1=ID2 AND (COL1=COL2 OR COL1=COL3) AND (COL1 =^ COL5) AND NOT COL6="…"
I can do it now with a workaround and using several nodes (rule based row filters ecc…) or scripts but it’s not so easy…
I hope, it could be an idea for new knime releases…