Details for joining tables with Regex

in the following post (JOIN with the help of regex) there is a reference to another discussion which has been removed/deleted (refer https://forum.knime.com/t/join-2-data-sets-using-contains-value-in-joiner-node/66655) which may assist with some work I am currently doing - is there a specific reason why it has been removed?

cc. @gonhaddock

1 Like

Thank you @iCFO for the prompt response - will investigate.

1 Like

You have to use SQL syntax and occasionally have duplicate the same test with different wildcard placements in order to have a contains test that covers if it falls first / middle / last part of a string, but there are some examples of that in @takbb demo workflow. Not hard when you put a few minutes into learning it.

He also has a simpler “contains” joiner if you don’t need to combine multiple types of criteria tests.

1 Like

Hi @zovanti , if you have some specific data samples that you are working with , I’m sure one of us can advise on what would be the most suitable option for you.

1 Like

Thank you for the offer @takbb - if I hit any challenges I will certainly take you up on this generous offer.

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.