I am building a model where,
I have two excel sheets with the same data, sometimes could happen that in both some data are different,
after a Join node I have three tables
how can I find the differences into the rows and how can I find where’s the differences?
ID: AAAA455256 (LEFT UNMATCHED TABLE)
ID: ABAV455256 (LEFT UNMATCHED TABLE)
the system have to recognize the differences
ID: A BAV455256
Thanks in advance for you support
Are the IDs in the same row, in different columns? What exactly do you want to output? The indices of the differences (e.g. [2, 4])?
it sounds like a string distance problem rather than a joiner one.
There’s many examples on the hub you can look at, but first we need to understan the problem better.
Could you explain more in detail what you need to do?
Hi @lelloba and @AlexanderFillbrunn ,
thanks for your support
in red what is different,
is it possible to create two different excel like the example?
thanks for your help
This is not really possible, as KNIME does not have the ability to store individual characters in different colors. It just stores the text content of a cell.
not possible to show what is different?
It is not possible in the format you require. KNIME cannot color individual letters in a cell in a different color. It is possible (using some coding) to find out where the Strings differ, but the output can most likely only be a list of indices of the letters that differ.
Table Difference Finder node?
The Table Difference Finder only shows you which cells are different, but it does not show you any differences within the cell content.
@AlexanderFillbrunn suggested that it was possible to find out where the strings differ. I have created a flow that does that
The output looks like this:
I hope this helps
I can working on this to perform by my needs
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.