Multiline user based entry in dashboard

[rkehrli]

Hello

I’ve created a workflow to generate a table output based on a number of item numbers in a table.

Currently I’m inputting the item numbers my colleagues give me into a Table Creator and forward that into my workflow.

My plan is to turn that into a dashboard “application” where users can enter 1 or multiple item numbers and have that output into a Excel sheet.

I am using the Table Creator with a Table Row to Variable node to tell the DB Row Filter what rows to read:

So I’m looking for a solution for the user to:

• Enter 1 to n 9 digit numbers in a dashboard
• Turn that into a set/array variable

A single-line String Widget works but I’d prefer being able to enter multiple numbers as it’s used for an item costing analysis and we often get a bunch of item numbers we need to check.

Note: I’m currently “stuck” on KNIME 5.2.4 so it would be helpful if you could help me with nodes that work on that version.

[iCFO]

The String Configuration node should support multi-line.

• Editor type

Single-line editor supports only one line text data and is represented with a text input component. It also comes with a validation based on regular expressions.
Multi-line editor supports many lines of text data and is represented with a text area component. Its sizes can be parameterized (see the options below) and the scroll bar will automatically appear, if the text is too long.

String Configuration – KNIME Community Hub

[mlauber71]

@rkehrli you could create an interactive selection based on values from a column and then filter with the results.

You can then use the results from the Interactive Value Filter Widget to apply that to your data.

Maybe you can adapt this

DataApp Dashboard - Interactive BoxPlot – mlauber71

Also: based on the selection you can do some manipulations in KNIME and then present the results in a table and save them into an Excel file: