Web UI - Is it possible to import a CSV into single selection widget

[barrycasey]

Hi

I have a workflow where a user can input an ID manually
Its been asked can this be changed to a dropdown so that a list of maybe 400 options can be selected.
Now this is done easily but the list of options is dynamic and always getting updated.
Is there any way to use a CSV with all the options availble and have it integrate with a single selection widget?

And also can it populate a corresponding values (Found in the csv) and display in the next box called

[AlexanderFillbrunn]

Hi,
you can either turn your values into a string list flow variable and control the Single Selection Widget with that, or you can replace the widget with a Value Selection Widget. In the latter case, when you have more than 60 possible values, you need to prepend a Domain Calculator node, because by default KNIME only stores possible values for a column if there are 60 or less.

Single Selection Options from Table.knwf (15.7 KB)

I think your second question is cut short, but I assume you want to filter what is shown in the other widgets when the user selects an ID. This is possible with the Single Selection Widget’s re-execution functionality. Have a look at this workflow for an example.

Kind regards,
Alexander

[barrycasey]

Thanks Alexander. Answer is much appreciated