Two strings-types columns and the frequency of their values' combination. How can I plot them?

[lulu]

Hi all,

I would like to plot the attached table, but I do not find a smart way to do it...

I would like to have the "Value 1" in the x-axis and the "Value 2" in the y-axis, reporting also the frequency of their combination.
I figured out two possible methods:
- A bubble chart with the bubble size representing the frequency:
    I didn't manage to do it, being the x- and the y- values string-types
- A matrix/table (MxN values) were every cell has a gradient of color related to the frequency:
    Is there something similar in the KNIME nodes/ BIRT Reporting?

Does anybody have a better idea how can I plot my table or can anyone answer my questions?
Thank you very much for your help,
Lulu

• table1.png

[ferry.abt]

Hey lulu,

does the attached workflow do the job?

Best,
Ferry

• plot_to_string_frequencies.zip

[lulu]

Hi Ferry,

thank you very much for your help!

It is a great idea! At the beginning didn't work, maybe because the too huge amount of data I had. I tried to use a "Edit Nominal Domain" instead of a "Size Manager" node, and now seems to work.

Best,

Lulu