Multiple Selection Widget to determine on dispayed List Box Widgets

KNIME Analytics Platform
1

Happy festive period everyone,

Hoping someone can give me some guidance on the below conundrum.

I have a component with a Multiple Selection Widget where user selects a Row (labelled 1). The result of this selection is then used to determine the possible choices for the second Multiple Selection Widget (labelled 2).

I then have a joiner that brings in a value called Category for all of the selected tables. (labelled 3 below)

My flow is shown below along with example output.

image
image1398×527 107 KB

image
image418×112 16.4 KB

The bit I am struggling with is that, as per screenshot below, I have List Box Widgets in the same component for each of the categories. What I would like to achieve is to use the column Category1 from screenshot above to filter the List Box Widgets that are visible to the user.

image
image777×451 37.6 KB

In other words, only the Input boxes that are relevant to Tables 1, 2, 3, 4 and 7 as shown below should be included in the Interactive View.

image
image1275×888 57.1 KB

I’ve attached the workflow for your reference.

KNIME_project2.knwf (113.0 KB)

I’m really close I think but I can’t quite figure out how to use join the Multi Select widget output with the individual List Box Widgets. I did think about using a case switch but i’m trying to avoid having duplicates of the list box widgets for each path (given that the user could select any combination of tables).

I’d really appreciate any guidance you can provide on this :slight_smile:

Thanks in advance.

Pete

2

@taylorpeter55 greetings to you as well. You can do it like this. You filter for the item you want. Then use and Empty Table switch to activate or de-activate the List Box Widget. In case of an empty entry, it will provide an alternative (empty) column

image
image835×494 24.9 KB

This will then result in dynamic change of your DataApp

image
image1006×757 16.7 KB

You can also activate automatic re-execution one an item has changed:

image
image608×180 11 KB

You could think about how to handle the Refresh Button. If you connect it to your Table Creation nodes the other entries will also be reset. You might have to play with that.

1 Like
3

Hi @mlauber71 ,

Thanks so much for your quick response, appreciate it.

I’ll have a play about with this tomorrow and mark as solution once i’ve got it working :slight_smile:

Thanks.
Pete

1 Like