Comparison of almost similar values

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"))

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

2 Likes