Comparation between 2 columns no exactly 100%
Hello group,
Working with KNIME, and my dataset. I needed to make the comparison between existing references in 2 different columns.
What is my problem, and that’s why I ask for your help…
As an example, I have in column A has the reference AAA11122222BBB-333CCC and column B to compare is 0AA11121222BBBB333CC.
As you can see some character or some is changed, but both strings match at 80% and therefore I would like that for that case it appears as “match” between both.
Can someone help me to do the Workflow?
Thanks in advance