We are working on a KNIME Workflow where BI users need to visualize and interact with the tables for data validation on the Server (Large KNIME Server) during the workflow execution.
For this validation step, we would like to know if it is possible to have a drop-down list in cells of a column as in this screenshot :
Welcome to KNIME forum.
If you have a table with names Row Nominal Value Filter will do the job. Filtered value could be submitted as parameter for the rest of WF.
I’m not sure it solves our issue, we don’t want to filter data but to lock the options for manual values selection in the table editor.
A field with only controlled value but no dropdown list or autocompletion in the editor would not be appropriated as our actual goal is to have an ergonomic UI.
You can see a sreenshot of an example of what we would like :
sounds interesting what you are trying. You said it is for data validation? Is it a big table? Can you tell me where would you have this options come from? A column from the same table or would be defined separately? Ideally I guess you would like both drop-down and autocomplete on the cell?
Unfortunately currently to have a drop-down in a cell is not possible. Actually I don’t think it is possible to add a column to table using just Table Editor node in a Component on a WebPortal. At least I haven’t found a way.
What could be done are two things. One is a feature request for this use cases and another is workaround. I can share example once I have all information.
just to follow up: there is already a feature request for it and I have added +1 on it.
@tttpham Actually not sure how effective this workaround would be but still I can share idea. You can build Component in a loop which goes row by row (Chunk Loop) and then you go row by row on WebPortal. In Component you add Value Selection Widget, Table View and Constant Value Column that in each iteration writes down chosen value. If you have table with 10 rows this might be ok but with more rows this wouldn’t be effective at all.
Thanks for your reply.
I understand what you suggested, the image is clear enough. Thanks for sharing!
However, as you say, this will be ok with a small table. In our case, the table is about 230000 lines @@, so it’ll be complicated without the “inline cell drop-down list” in the table editor…
About the feature request, we can also vote for it ?
I see. Won’t work for that many lines. But having a inline cell drop-down list will also take a lot of time when having 230.000 lines or I’m missing something?
It is actually a really long validation process. The users need to see the data all together, do some check and then validate line by line. So, it’ll be a great help if they can edit directly the cell in the table.
You can provide me with the link to the feature request please ?
tttpham, with the volume of manual work the automation may be the better option. All the checking your mentioned have to be formalized, if possible, and automated. Try to solve the bigger task. The one on hand may not worth a separate consideration.
Having a similar user story, we implemented a Generic Javascript View node (JS code) which reads the content of the table, creates an HTML table from that, and adds one dropdown per row into the last column of this custom table visual. I cannot share our code but it is quite straightforward.
Output vairable can be a dictionary between your original rowID and the newly input values, so you could join the manually selected values back to your original table.
However, when it comes to 200k lines, this approach might get too slowly performing (our case works well but we have only ~100 lines max)
:
