I need to color code some elements of a cell, pending on a score in another cell.
For example
Grade
A John 95
A Amy 90
C Lisa 40
where A would be green and C would be red (but the name remains black).
Is there a way to do this? I have been playing withe the Color Manager node, but with no success.
Thanks in advance for the help!
Hi @Isa -
I was just typing a response about this in your other thread. There’s not really a way to make this work on standard KNIME table data. But:
if you wanted to use a Table View (Javascript) node to display the results, you might be able to make use of the CSS Editor node and do it that way.
Having said that, a simpler thing to try might be to use a combination of the Numeric Binner and Color Manager nodes to assign colors based on a score, and then have those colors show up in a Table View (for the entire row, not the text itself). Maybe that’s good enough for your purposes?
Hi @ScottF , would it be possible to give me a workflow example illustrating what you describe above? That would really help me I think. Many thanks.
What about something like this? It’s nothing fancy, but the table and scatter plot interact with each other in the combined visualization. I’m sure you could improve upon it.
GradesColorVizExample.knwf (22.2 KB)
Thanks. i was hoping I could get the star to be color coded directly in the name column somehow, but that does not seem possible. (it becomes a legend in a bar chart afterwards, so it would have been great to visualize it that way). As suggested, I will think about alternative visualization suggestions.
You might be able to do it in the BIRT reporting tool part of KNIME, with conditional formatting.
Steve
