Good morning , I have two columns to compare which represent the same serial number of a device. However, the complete number has been entered in the first column, while the last digits have been entered in the other. Is there a way to make the comparison? column 1 * column 2 * 1234567890 * 67890 * 1232678948 * 78498 * 586318819 * 18819 * …

Hi @pollyste You want to check if column1 contains the value of column2? In that case you can use: contains(column("column1"),column("column2")) [image]

Nice, but fi they arrived from two different tables is hard?

Hi @pollyste For joining similar values between tables, you may find this of use [image] Workflow Demo Joiner Components KNIME Community Hub Workflow demonstrating the use of the Joiner Components The joiners provide the following functionality: This is a companion discussion topic for the original entry at https://kni.me/w/4_eVfOR3f-EMpo2s

Comparison of almost similar values

KNIME Analytics Platform

takbb November 20, 2022, 10:30am 4

Hi @pollyste

For joining similar values between tables, you may find this of use