Joiner node improvement (suggestion)

Hi,

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?

e.g.

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…

3 Likes