Is there any way in KNIME to modify the data by hand, I cannot find any way to do it.
Ideally what is wanted is something similar to the Interactive Table viewer node with an out-port. In the table viewer you can modify the values or strings within the cells to whatever you wish, and delete rows if desired. Then as soon as the table viewer window is closed the workflow continues through the out-port with the modifications made.
The reason I ask for this is to set up a chemical inventory in an excel sheet which is put on a server. I then set up a KNIME workflow to allow substructure searching in the database, in which it reports back the amount of material and location. But I want it easy for the material and location to be modified by the user. i.e. once user finds the chemical they want from the substructure search, they can change the location to them and then go and collect it, then the modified data is written back to the excel sheet with an XLS Writer node.
I dont want to be using String Replacer nodes to change the content, as that will be too cumbersome for the user.
Any thoughts.
Simon.