Hi,
I have a dataset with foods, chemical food compounds an measurement values.
Now I want to build an interface via component which has a text input window, where different foods are suggested depending on the input.
For example:
If I write into the text window: “a” → all foods with a are suggested via dropdown
If I write further to “apple” → all apples are listed.
Then I can choose one of the displayed entries and my table with the food compounds and measurement values are displayed.
I think what you are after can be done via multiple selection widget:
You take your main data set and use a group by node. Don’t group any column, but under manual aggregation select your column that has all the values e.g. apples, oranges etc and use “set” as an aggregation function.
Next use table row to variable node to turn the row that now contains all possible fruits as a set into a variable. Connect the variable to the multiple selection widget.
In the multiple selection widget config:
Set selection type to combo box and in flow variable tab use the set flow variable to define possible choices.
Under Re-execution tab then check the box so that any value selection change triggers re-execution.
Now take your main data set and connect it to a reference row filter. The other port of the reference row filter you connect to your multiple selection widget. Co figure the reference row filter to filter your main data set for the values that come out of the multiple selection widget. Now “wrangle” the filtered data into the view you want to show your user and then connect it to table view node.
Once that is done select all nodes and create a component.
The multiple selection widget should allow you to start typing and should suggest options based on what you type. Whenever something changes, the table view will refresh…,
Yes, I put the set as flow variable into the default values in the multiple selection widget.
When I start typing in the empty row, unfortunately nothing ist displayed
