Icon

09. Flow Variables & Components - solution

Flow Variables Solution

Solution for "Flow Variable" exercise for advanced Life Science User Training
- Filtering rows by an attribute value
- Filtering rows by an attribute value that fulfils a condition and that is updated automatically
- substructure search based on a drawn reference molecule

URL: Slides for KNIME Analytics Platform Course (L2-LS) https://www.knime.com/form/material-download-registration
URL: From Data to Variables https://www.youtube.com/watch?v=Y8hVkTvHR9I&feature=youtu.be
URL: Flow Variables https://www.youtube.com/watch?v=Y8hVkTvHR9I&feature=youtu.be

Filtering by Selection & Flow Variables

In this exercise, we will use Flow Variables to overwrite node configurations. Filter the compound data to filter the one compound that was tested the most across the assays.

Hint: you need a GroupBy, Sorter, Table Row to Variable and then the Row Filter

Use the Value Selection Configuration Node to allow a selection of a value from the assay_chembl_id and use it to filter those values in the Row Filter node. As a second step, create a component including both nodes. Where do you find the value selection options?

Exercise 1
Exercise 2

Run the same exercise as above but use the Value Selection Widget instead. If you create a component, where do you find the selection options now?

Inside of the component: add a Table View after the filter and check the box for re-execution in the widget node. Try the component again.

Exercise 3
Assay Selection
CHEMBLID228_SERT_ligands.table
Table Reader
Row Filter
Value Selection Widget
CHEMBLID228_SERT_ligands.table
Table Reader
Row Filter
Assay Selection
Value Selection Configuration
CHEMBLID228_SERT_ligands.table
Table Reader
Row Filter
Table Row to Variable
Sorter
GroupBy

Nodes

Extensions

Links