Icon

06. Databases - solution

Databases
- Drag & drop the malariahts_DB.sqlite file into your workspace
- Connect malariahts_DB.sqlite to the two DB Table Selector nodes to read the "malariahts_experiment" and "malariahts_molecules_feature" table, respectively
- Filter the Column called "Pf3D7_pEC50" in the "malariahts_experiment" table with the Database Column Filter node
- Join the two tables together with the DB Joiner node using "Sample" column
- Read the data into KNIME using the DB Reader node.
- Write the data into a csv file

Databases

readmalariahts_molecules_feature
DB Table Selector
read malariahts_experiment
DB Table Selector
join two tableson sample
DB Joiner
Filter Pf3D7_pEC50 Column
DB Column Filter
Read data intoKNIME
DB Reader
CSV Writer
SQLite Connector

Nodes

Extensions

Links