How to find out the duplicates and highlight in different colors the values in same column?

Hi All,

I new to Knime may be its very easy question someone help me out thanks in advance! i would like to compare the two columns and highlight the differences here

Eg
COL 1 COL2
KDU137318/1 8523.51

KDU137318/1 8542.32

KDU137318/1 8542.32

KDU137318/1 8542.32

KDU137318/1 8542.32

First row is want to identify as wrong and color code the difference

Hello @Raj_22,

and welcome to KNIME Community!

You can not highlight a certain cell in KNIME that easily. Coloring node, Color Manager, colors only row. Now to your questions. To spot such differences I would suggest to go with Duplicate Row Filter node which can output unique, duplicate and chosen labels. Now you need to translate them for your use case. Duplicate and chosen would be correct (same value) and unique would be wrong. To do this mapping you can use Rule Engine node. Then above mentioned Color Manager node can color correct vs wrong rows.

As you might need this for different groups you should do a loop. Looping over group is done with Group Loop Start node.

Give it a try and if any questions/issues feel free to ask. Hope this helps!

Br,
Ivan

2 Likes

Hi Ivan,

Appreciate your help let try this way and keep you posted!

BR
Raj

1 Like