I have a question regarding the value selection quick form. I am building a data table used as an entry to this quick form from a list of Excel sheets. This list contains hidden sheets that I filter using a rule-based row splitter. This filter works fine as I do not see the hidden sheets in the data table used as input table to the quick form. Unfortunately, when I run the workflow (either in the client or the knime server), these hidden sheets are still available in the dropdown box. I do not understand this behavior; how can I fix this so that the form displays only a valid list?
Thanks in advance for your help,
It’s difficult to judge without having the workflow, but in a way sounds familiar. Have you tried using a domain calculator node after the row splitter node in order to recalculate/refresh the metadatas ?
No I have not tried it. I found a workaround by rebuilding the table with a groupBy (concatenate), Table Row to variable, then a variable to table row, a cell splitter,an ungroup… a little bit cumbersome but it works…
I’ll try your solution to see if it works in my case. Thanks,
Your solution works just fine. Much much better - thanks a lot.
The reason these sheets are still available after filtering is because domain information is not automatically refreshed/calculated. As @Fabien_Couprie suggested using Domain Calculator node should help
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.