Color Manager Loop

KNIME Analytics Platform
1

Hello KNIME Community!

I’m currently chunking my dataset into groups of two rows and then identifying the differences between these rows by transposing the table and using a rule engine to flag the discrepancies.

Next, I need to highlight the columns that are different, so I’m trying to set up a variable loop start to apply the color manager to the different columns.

However, this approach isn’t working as expected. Do you have any suggestions on how to resolve this issue?

2

Hi,

If I understood you correctly, you’re working with a two-row structure and need to check for differences across columns.

I’ve prepared a sample dataset and a sample workflow to help visualize the problem. This might be a good starting point for exploring the solution further.

Let me know if anything needs clarification!

Best regards,

Alpay

KNIME_Compare_2Rows_100Cols.xlsx (6.6 KB)
Row Check.knwf (23.1 KB)

2 Likes
3

Hi @alpayzeybek,
thanks for the brainstorm!

I managed to get to a similar point, but the issue is when the table get transposed again (from vertical to horizontal), it looses the color formatting.
Do you have any idea of how to solve it?.

Thanks!

1 Like
4

Thanks for the follow-up!

One idea could be to append not just the color formatting, but also an additional column where you assign an integer value corresponding to the color per row. That way, even after transposing the table back to horizontal, you can track which columns could be filtered based on those integer values.

Let me know if that helps!

Best,
Alpay

1 Like