Output Images in New Column

[chiashin]

Hi people,

I’m discovering the Python Script node lately and wondering if there is any effective way to perform the task I’m doing.

For example,
User | Data_X | Data_Y |
User_A | 1 | 1 |
User_A | 2 | 3 |
User_A | 3 | 5 |
User_A | 5 | 7 |
User_A | 7 | 9 |
User_B | 8 | 1 |
User_B | 9 | 2 |
User_B | 2 | 3 |
User_B | 3 | 9 |
User_B | 5 | 2 |

I will need to generate images (eg. a plot graph) based on User_A and User_B using the data from column Data_X and Data_Y respectively. The images generated (.jpg format) will need to be stored in a new column in the same table, namely Column_Image. So, based on the above dataset, there will be two images generated. If possible, I wish to include some info for the images like which User it should refer to.

Expected output:
User | Data_X | Data_Y | Column_Image | Image_Description
User_A | 1 | 1 | Image_A.jpg | Image User A
User_A | 2 | 3 |
User_A | 3 | 5 |
User_A | 5 | 7 |
User_A | 7 | 9 |
User_B | 8 | 1 | Image_B.jpg | Image User A
User_B | 9 | 2 |
User_B | 2 | 3 |
User_B | 3 | 9 |
User_B | 5 | 2 |

I can think of using the Python Script node to do the task, but somehow it can’t work. Do I need to include other nodes or functions? Do I need to create separate tables?

Thank you.

[mlauber71]

@chiashin maybe you can take a look at this discussion and example. Storing image files in an SQLite from within Python and reading it back into KNIME. Maybe you can adapt that.

Python Script - export images in table

@ActionAndi what you can do is store the PNG file in a SQLite database and then read it back into KNIME. [image] Just make sure that you have an actual PNG file (binary) and store it as a BLOB data type in SQLite. If you read it back to KNIME make sure the column “data” with the image is defined as a PNG file: [image] You might be able to combine these approaches: You can extract the current surroundings from a node. I have also created a component for that: