Problem with names in data preparation

[wkhan]

Hey @LilianaGarcia,

It sound like you’re asking how to to a LIKE join. Check out these Forum posts:

Column Join on partial string match?

Hi @Cardinal_Fire, You can do this in KNIME by creating a dedicated joining column that just contains these first 7 characters. An easy way would be with the String Manipulation node, I have attached a workflow that demonstrates how to do this. Joining example.knwf (9.7 KB) best, Gabriel

Join KNIME table by like

What node I can use to join two KNIME tables by like criterion. Ex. $Organization_T1$ like ‘$organization_T2’ Igor

Regards,
Wali Khan