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.

Output Images in New Column

mlauber71 June 7, 2023, 8:37am 2

@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.

1 Like