Comparison of almost similar values

KNIME Analytics Platform
1

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 *

ā€¦

2

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
image1143Ɨ579 22.2 KB

3

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

4

Hi @pollyste

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

2 Likes
5

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